Although typed datasets can use the same syntax as untyped datasets, there are additional advantages to using typed datasets.
For more information, see the "To update existing records using typed datasets" section below.
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.
Now sometime we have a requirement like, some rows of that Data Set (having Data Table) may get Updated with new values and some may have been Deleted or there may be another possibility of Insertion of new row in that table.
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.
The first step is to update the dataset with new records, changed records, or deleted records.So Let’s start with post with a very often situation in our coding life.Generally we used Data Set for having the collection of Data.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).Additionally, new records can be inserted into the dataset by adding new Data Row objects to the Data Table objects' Rows collection.