private void dataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e) { int col = dataGridView1.SelectedCells[0].ColumnIndex; int row = dataGridView1.SelectedCells[0].RowIndex; if (col == 5) { if (dataGridView1.Columns[col].Name.ToUpper() == "GIATIEN") { string GiaTienUpdate = dataGridView1.SelectedCells[0].Value.ToString(); string IDSuDungDichVu = dataGridView1.Rows[row].Cells[4].Value.ToString(); string sql = "UPDATE DBA_USER.DANH_SACH_SU_DUNG_DICH_VU SET GIATIEN=" + GiaTienUpdate + " WHERE ID_SUDUNGDICHVU=" + IDSuDungDichVu; TaiVu.runSQL(conn, sql); } } }
private void label13_Click(object sender, EventArgs e) { string Ma = dataGridView1.Rows[rowInsert].Cells[0].Value.ToString(); string Ten = dataGridView1.Rows[rowInsert].Cells[1].Value.ToString(); string Gia = dataGridView1.Rows[rowInsert].Cells[2].Value.ToString(); if (num == 1) { sqlInsert = "INSERT INTO DBA_USER.THUOC VALUES(" + Ma + ",'" + Ten + "'," + Gia + ")"; } else if (num == 5) { sqlInsert = "INSERT INTO DBA_USER.DICH_VU_KHAM_BENH VALUES(" + Ma + ",'" + Ten + "'," + Gia + ")"; } TaiVu.runSQL(conn, sqlInsert); MessageBox.Show("Đã thêm thành công!"); }
private void dataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e) { int col = dataGridView1.SelectedCells[0].ColumnIndex; int row = dataGridView1.SelectedCells[0].RowIndex; if (col == 2) { if (dataGridView1.Columns[col].Name.ToUpper() == "GIATHUOC") { string GiaThuocUpdate = dataGridView1.SelectedCells[0].Value.ToString(); string MaThuoc = dataGridView1.Rows[row].Cells[0].Value.ToString(); string sql = "UPDATE DBA_USER.THUOC SET GIATHUOC=" + GiaThuocUpdate + " WHERE MATHUOC=" + MaThuoc; TaiVu.runSQL(conn, sql); } else if (dataGridView1.Columns[col].Name.ToUpper() == "GIADV") { string GiaDVUpdate = dataGridView1.SelectedCells[0].Value.ToString(); string MaDV = dataGridView1.Rows[row].Cells[0].Value.ToString(); string sql = "UPDATE DBA_USER.DICH_VU_KHAM_BENH SET GIADV=" + GiaDVUpdate + " WHERE MADV=" + MaDV; TaiVu.runSQL(conn, sql); } } }