private void dataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e) { DataTable dt = ((DataTable)dataGridView1.DataSource); string id = dt.Rows[e.RowIndex]["id"] + ""; string col = dt.Columns[e.ColumnIndex].ColumnName; string data = dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value + ""; string sql = string.Format("UPDATE hosts SET `{0}` = '{1}' WHERE id = {2};", col, data, id); srvmgr.UpdateInsertDeleteData(sql); }