Binding DataGrid with DataTable

Question

 Hi,

    I have a DataGridView which have some columns which includes one ComboBox, two CheckBox and rest TextBox, i am binding these controls with the Datatable.

    The problem i am facing is given below.

    I can Load the Grid with values in Database,
    I can delete the rows of the database using Grid
    But i cannot modify the database values using grid.

I checked the DataTable to ensure that when i am calling "da.Update(dt)" the latest DataTable with modified values is updated.

Here the DataTable contains the modified value but on updating the database value is not changed.

I am using C# language and MySQL database.

Even with SQL it is not working..


Please Help Me.....

Thanks Regards
Akhil.N.P
 

---

Akhil.N.P

Answer 1

Here is msdn documentation (concepts and tasks associated with saving data from your application to a database.)
http://msdn.microsoft.com/en-us/library/ms171932.aspx

Here is an example
 http://www.codeproject.com/KB/database/DataGridView2Db.aspx

---

This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to mark the replies as answers if they help.

Answer 2

Thanks Mark, that link was very helpfull..

---

Akhil.N.P