Update Database with Changes made to the DataGridView

Question

hey frnds Firstly I pick the records from the databse into the DataGridView Then I want that If we made changes to the records in the GridView & Click on Update Button Changes are Reflected into the Datbase .Plz do reply back

Vijaya Kadiyala · Answer

Hi As Bechier suggested you can use methods of the DataAdapter to commit changes at the database level but i would always recomend to write explicit UPDATE statements to the database to avoid any confusion in future. Thanks -- Vj http://dotnetvj.blogspot.com

Bechir Bejaoui · Answer

In fact the problem is that when you make changes those last ones affect only the dataset witch is a in memory cash they aren't saved back in the database: Use the update method of the DataAdapter to commit changes at the database level