I am wanting to be able to have an editable datagrid where once a cell
value is changed, it will update only that value in the database (MySQL
4.0.17). First I populate a DataAdapter, fill the DataSet and point
the DataGrids DataSource to the DataSet. When I try and use the
DataAdapter.Update, I get an error. I believe I have to specify my own
UpdateCommand. That is my problem. I am basically trying to create a
GUI to edit my MySQL tables. So a user can click the table, and the
datatable will display all the contents of that table, so I believe the
UpdateCommand will have to be different every time. I would also like
them to be able to delete and add new rows if needed. All the
information is displaying properly, just need to be able to edit it
now.
I have been going through forums for about a day with no luck. Any
information would be appreciated (especially code examples), or a good
site that explains what I need to do. Thanks.
|
Similar Threads
