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.
Until now, you’ve created the data adapter by passing in a command string and a connection string to the Data Adapter object’s constructor and then calling the Fill method.
It turns out that Fill interacts with the database by creating a command object on your behalf and assigning that command object to the Select Command property of the Data Adapter object.
Before we discuss how to write back changes, let As explore Data Adapter class in a bit more detail: We have discussed Select Command property which lets the Adapter selects its query.
Using bind variables makes the statement reusable with different input values.