If IsNothing(TestDataSet1) Then Exit Sub
'prompt to save changes
If MsgBox("OK to delete?", MsgBoxStyle.OkCancel, "Confirm Delete") = MsgBoxResult.Ok Then
'delete it from the dataset
TestDataSet1.Eggs.Rows.RemoveAt(ListBox1.SelectedValue - 1)
EggsTableAdapter1.Update(TestDataSet1)
End If
' this doesn't seem to be working
' i have a listbox bound to datasource, display member "nick" and value member "ID" where id is the primary key starting at 1....
' this asks for the index of the row which starts at 0, so i - 1 from the selected value "ID" to give the correct index #.
' i'm not sure but this just isn't deleting the row from the database ....