Q
Problem solve Get help with specific problems with your technologies, process and projects.

How do I delete a record in a database?

How do I delete a record in a database? I use SQL Server 2000 as my database and I use textbox to bind the data. I already used this code but it didn't work:
  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

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchCloudComputing

SearchSoftwareQuality

TheServerSide.com

Close