Updating the database using dataset and dataadapter

by  |  05-Jan-2015 18:12

updating the database using dataset and dataadapter-70updating the database using dataset and dataadapter-32updating the database using dataset and dataadapter-12

While you can still use Execute Non Query to save the data back to the database, but this is not the superb way sometimes if you have a lot of data to save.

While it is true that you can save the data easily using the dataset control and data adapter, sometimes you need flexibility in your application in accessing your database. If you are accessing a master file in one of your table I suggest you use the dataset and data adapter control.

In this case, all those rows in emp whose foreign key value is the deleted department ID would be unstable; there would exist no department for these employees to work.

To resolve such issue, there is Data Relations collection in every Dataset.

Similarly, Fill command reads the results of Data Adapter query into Data Table of the dataset.

Updating the database using dataset and dataadapter

User
Senior health is always a big chat topic for the experienced seniors.…
dating in mid wales
User
Including everything from paintings to mixed media installations you will be illuminated by the “Obras Maestras”, or masterpieces of Puerto Rican artists like; José Campeche and Francisco Oller.…
whos sabrina bryan dating

Community Discussion