So Let’s start with post with a very often situation in our coding life.

database dataset from updating-45

Here I want to let you know that every changes that we have done with dataset, Dataset retains the Row State value for each row and then according to this Row State value.

It perform the appropriate operation(Insert or Update or Delete).

NET application by specifying command syntax at design-time and, where possible, through the use of stored procedures.

You must explicitly set the commands before calling Update.

A Data Set is an in-memory data store that can hold numerous tables.

Data Sets only hold data and do not interact with a data source.The Update method of the Data Adapter is called to resolve changes from a Data Set back to the data source.The Update method, like the Fill method, takes as arguments an instance of a Data Set, and an optional Data Table object or Data Table name.Row State value can be : More you can get about these State from MSDN. Step 1: We have a Data Base Helper Class which have a function which return a Sql Data Adapter object of our datacollection Here I am writing SQL Query inside this function.you can even use Stored Procedure or any thing you want but store result into Sql Data Adapter.Now we use this Data Set as a Data Source of any of the Data Control like; Grid View, List View etc for showing this Data to User.