How do I update the dataset with the updates in records?

You can update the dataset by calling the Update() method of the data adapter.

C# Version

  DataTable dt = ds.Tables["Article"]; dt.Rows[2]["lines"] = 600; da.Update(ds, "Article"); 

VB.Net Version

Dim dt = ds.Tables("Article") dt.Rows(2)("lines") = 700 da.Update(ds, "Article") 

Here ‘da’ and ‘ds’ are the references of the DataAdapter and DataSet objects respectively.