I am new to SQL and VB and have searched for a soluttion to this problem to no avail. I have a database that is used to fill a DataTable which I bind to a DataGridView as follows:
bsStreets as New Binding Source
StreetAdapter.Fill(DTStreets)
bsStreets.DataSource = DTStreets
I then delete a row in the DataGridView as Follows:
dgvStreets.Rows.Remove(dgvStreets.CurrentRow)
dgvStreets.BindingContext(DTStreets).EndCurrentEdit()
DTStreets.AcceptChanges()
StreetAdapter.DeleteCommand = cbGetDeleteCommand
StreetAdapter.Update(DTStreets)
This deletes the row from the DataGridView and the Datatable but Doesn't change the underlying DataBase.
Can someone tell me what I am missing?
Thank You
Brad
BHend ...
Go to the complete details ...