示例#1
0
        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);
        }