Update using DataGridView Control
Posted on 2006-12-01
I am trying to teach myself how to use the DataGridViewControl. What I would like to do is simply display data from a table of my MySql Database, and then click on any row item, edit the item, and update my mysql databse after the user presses enter or clicks save.
I have been able to display data from one of my MySql tables, but I can't seem to get a grasp on how I can update my database with the edited cell. It appears as this would be easier if I was using SqlServer, but i must use MySql. I posted my code that I used to load the DataGridViewControl.
private void InitializeDataGridView(DataSet ds)
for (int i = 0; i < ds.Tables.Count; i++)
DataRow newRow = ds.Tables.NewRow();
newRow.ItemArray = ds.Tables[i].Rows.ItemArray;
dataGridView.DataSource = ds.Tables;