private void butDel_Click(object sender, EventArgs e) { if (MessageBox.Show("Bạn có đồng ý xóa Email?", "Medisoft THIS", MessageBoxButtons.YesNo) == DialogResult.Yes) { sql = "delete " + user + ".dmemail where id=" + id; m.execute_data(sql); } load_grid(); dataGridView1_CellClick(null, null); }
private void btnLuu_Click(object sender, EventArgs e) { dataGridView1.Update(); dt.AcceptChanges(); foreach (DataRow r in dt.Rows) { string sql = "update " + acc.User + ".syn_manager_schema@" + dblink + " set syn=" + r["syn"].ToString() + " where mmyy='" + r["mmyy"].ToString() + "'"; acc.execute_data(sql); } load_grid(); }