Asp net updating database from dataset
The way the architecture works with the Data Adapter is that you can make any changes you want to the filled Data Set, and it won't affect the database until you call the Update method.
When Update is called, the Data Adapter will attempt to execute each query (UPDATE, INSERT, DELETE) on every row of the Data Set that has been updated, inserted, and deleted.
NET Data Set, which contains records from the Customers table of the Northwind SQL database.
The Web service uses the Update Customers method to accept changes to the records.
In Info Path, if the Web service resides in a domain other than where the form template is published, the user receives a cross-domain warning when the Web service is called.
Listing 5-48 show the code on the Insert Command button-click event.
From the Info Path client, the username is used to access the Web service, while from the browser, the Computer Name\ASPNET account is used.