How do I update the physical database with the changes in the dataset?
You can update the physical database by calling the AcceptChanges() method of the data set.
C# Version
DataTable dt = ds.Tables["Article"];
dt.Rows[2]["lines"] = 600;
da.Update(ds, "Article");
ds.AcceptChanges();
VB.Net Version
Dim dt = ds.Tables("Article")
dt.Rows(2)("lines") = 700
da.Update(ds, "Article")
ds.AcceptChanges()
Here ‘da’ and ‘ds’ are the references of the DataAdapter and DataSet objects respectively.
Back
