Start Database dataset from updating

Database dataset from updating

The Data Set instance is the Data Set that contains the changes that have been made, and the Data Table identifies the table from which to retrieve the changes.

you can even use Stored Procedure or any thing you want but store result into Sql Data Adapter.

For example, the Sql Data Adapter performs the following tasks when filling a Data Set with data: In between the Fill and Update operations, data source connections are closed and you are free to read and write data with the Data Set as you need.

These are the mechanics of working with disconnected data.

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.