Updating data in a dataset

Open(); Now we setup our adapterstring Parent Query = "SELECT * FROM Parent Table";string Child Query = "SELECT * FROM Child Table"; Sql Data Adapter Parent Adapter = new Sql Data Adapter(Parent Query, Connection); Sql Data Adapter Child Adapter = new Sql Data Adapter(Child Query, Connection); At this point we can fill our Data Set. Fill(My Data Set, "Child Table"); We have 1 Data Set with 2 Data Tables in it, Parent Table and Child Table. This means when you merge your 2 Data Sets nothing will get written to your database because nothing has changed.

; microsoft.support.content = (function(){ return { "click Tale Configuration": , "Internal Content Config": , "Mwf Configuration": , "Site Content Config": { "Link Farm Enabled": true, "One Site Service Uri": "https://uhf.microsoft.com//shell/xml/?

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.

Leave a Reply