Dim myrow As DataRow Dim mytable As DataTable mytable = Dsdataobatbebas1.Tables("dataobatbebas") myrow = mytable.Rows(Me.BindingContext (Dsdataobatbebas1, "dataobatbebas").Position) myrow.Delete() myrow.AcceptChanges() Dsdataobatbebas1.dataobatbebas.AcceptChanges() SqlDataAdapter1.Update(Dsdataobatbebas1.dataobatbebas) note: dsdataobatbebas1 is a dataset
AcceptChanges marks the row as having no change again, and that's why it doesn't seem deleted for the data adapter. It's effectively removed in the delete case. You shouldn't call AcceptChanges in the row or dataset, so that the adapter knows what changed. The adapter itself will call AcceptChanges after the method call.
Dig Deeper on Win Development Resources
Related Q&A from Daniel Cazzulino
Here Daniel Cazzulino explains how to load a DSL (domain specific language) domain model instance file programmatically. This requires the .NET type ... Continue Reading
Here we offer a glimpse at 12 of .NET development expert Danny Cazzulino's top ASP.NET questions and answers. Continue Reading
C# developers should NOT be modifying InitializeComponent method in the code-behind (or any of the variable definitions) by hand. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.