Updating dataset without dataadapter
So while the recordset could do almost any task, most code did not use it correctly-in some cases using inappropriate default values, and in others explicitly setting parameters in ways that were not optimal for the application at hand. NET, then called ADO , I was a little concerned: Calling this new technology by the same name as what we now know as classic ADO would cause no end of confusion. They expected a 2.0 sort of upgrade to classic ADO. NET was a totally new set of components, and it was optimized for the Internet world. NET, you can use either a Data Reader or a Data Set. There are a number of data providers, such as Sql Client, included with ADO.
I was also troubled by the lack of scrollable cursors and a number of other features not supported in ADO. NET, and each has its own implementation of the Data Reader.
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.
Now what we want is, this modified Data Set should Get stored in the database.
It is the Sql Data Adapter that manages connections with the data source and gives us disconnected behavior.Unfortunately, there are a number of occasions when this is not possible. A common use of the Data Reader to read through a result set would look like the following: When you get the results into the Data Reader, it’s important to note that the “cursor” or logical pointer into the returned data is just before the first row. When working with recordsets, the logical pointer is initially placed at the first row of data.To read records you must create a loop that contains a call to . I cannot tell you the number of times I forgot this when working with recordsets in classic ADO.Data Reader directly access the table and it is only used for reading the records from it whereas dataadapter, used to maintain connection, is always used with dataset as dataset is of disconnected-architecture in nature. The SSW rules are a great resource for developers all around the world.