How do I delete a record in the table using ADO.Net dataset?

To delete a record, you first get the DataRow object from the DataTable object. Then you simply call the Delete() method of the data row object to delete a record from the data table.

C# Version

DataTable dt = ds.Tables["Article"];
			
// Delete
DataRow dr = dt.Rows[3];
dr.Delete();
da.Update(ds, "Article");
ds.AcceptChanges();

VB.Net Version

Dim dt As DataTable
dt = ds.Tables("Article")
' Delete
Dim dr As DataRow
dr = dt.Rows(3)
dr.Delete()
da.Update(ds, "Article")
ds.AcceptChanges()

Back



 

Advertisement

Free Magazine