Updating dataset asp net
The following code shows a typical contains a client copy of the database data.
In this section, you will add a button that enables client data changes to be saved back to the database.
As you know, there are frequent modifications in database tables in real life.
These may include insertions, updates and deletions.
To make this more sophisticated model of data updating work, you will need to take advantage of the advanced capabilities of the Data Set and the Data Adapter classes, and you’ll need to understand how they in turn use the Command and Connection objects to mediate between the dataset and the database itself.
We have discussed that Data Sets can not directly interact with Database tables.The following section will show you how to test updating, inserting, and deleting the data.Datasets store a copy of data from the database tables.So far in this chapter, you have seen how to update a database and how to add transactions to ensure data integrity.All of that is fine as far as it goes, but nothing you’ve done so far to update the database takes advantage of the Data Set object, which you will remember is the keystone of ADO. If you are using the Data Set object to retrieve data and pass it from tier to tier within your application, you would also like to manipulate that data within the dataset and push the changes back to the database.