Updating dataset without dataadapter
The ADO Recordset object held a collection of records that we could scroll through. NET Data Set can do the same but can hold several sets of records and the relationships between them. NET Data Set is like a portable database containing tables and views along with the data description information that defines them. NET Data Set to be an in-memory database that we hold in our application's memory space (see the sidebar, "The Data Reader," for the one exception to ADO. In ADO, if we used a client-side Recordset, our data was disconnected from the data source.
NET has a Connection object that we use to manage our connection to our data source. Things start to get different when we look at the ADO. In many ways, the Data Set object looks like a weird amalgam of all of the old DAO objects holding tables, relations, and columns. To do that, the Data Adapter lets us specify the commands that should be carried out to retrieve and update data.
The Find method returns the row with Customer Id = Tst ID.
Note: Keep in mind that this Update is different than a SQL UPDATE statement.Disconnected Recordsets also made applications more scalable in other ways.In addition to reducing the load on the data server by reducing the number of active connections, the data server's load was also reduced because activities performed on disconnected data had no impact on the server.As you saw in the Data Table, Data Row, and Data Column sections at the beginning of this article, you can use the Delete method of a Data Row to delete a row.The Add New method of the Data Table adds a row to a Data Table.