CODEWITHSUNDEEP
vb.netms-accessvb.net-2010
Lasicak
Lasicak

Reputation: 19

Delete record from Access database vb.net

In this project I use Access database which is displayed in DataGridView. I am trying to delete acces row but i my looking for was not successful.

Code to delete record from DataGridView:

Private Sub DataGridView1_CellContentClick(sender As Object, e As DataGridViewCellEventArgs) Handles DataGridView1.CellContentClick

    Dim index As Integer
    index = DataGridView1.CurrentCell.RowIndex
    DataGridView1.Rows.RemoveAt(index)


 ZoznamBindingSource.RemoveCurrent().                                                                            
 ‘Dim da As OledbDataAdapter
  ‘Dim ds As dataSet                                                 
   da.Update(ds)
 End Sub

The last line of code give me an error: SystemNullReferenceException. I know rhe dataset is problem but i don’t know which code will replace it with.

Any solution?

Upvotes: 0

Views: 391

Answers (1)

jmcilhinney
jmcilhinney

Reputation: 54417

The whole point of a BindingSource is that it is the one and only point of contact for bound data. You shouldn't have to touch the UI and you shouldn't have to touch the data source.

In your case, you should be calling RemoveCurrent on the BindingSource. That will flag the underlying DataRow as Deleted and then, when you call Update on your data adapter, the corresponding database record will be deleted.

Upvotes: 1

Related Questions