Last post Nov 18, 2016 02:26 AM by Yohann Lu
Nov 17, 2016 02:18 PM|sudip_inn|LINK
suppose my dataset filled with records from database. i change few existing data in dataset and add few new data in dataset and also delete 2 data from dataset. now i want when i will execute accept changes function of dataset then change data should be
reflected in database. so tell me how could i do it by dataset. i do not want to write in line sql for CRUD operation rather i want my dataset will do it behind the scene.......is it possible?
Nov 18, 2016 02:26 AM|Yohann Lu|LINK
You can update data in the dataset can be sent back to the database by calling an Update method of the TableAdapter, or by calling a DBDirect method of the TableAdapter, or by calling the UpdateAll method on the TableAdapterManager that Visual Studio generates
for you when the dataset contains tables that are related to other tables in the dataset.
You can refer the following links.
Save data back to the database:
How to: Save Dataset Changes to a Database: