private void btnXoa_Click(object sender, EventArgs e)
{
if (this.dataGridView2.SelectedRows.Count > 0)
{
DateTime ngay = DateTime.Parse(this.dataGridView2.Rows[this.dataGridView2.CurrentRow.Index].Cells[0].Value.ToString());
if (!exedata($"delete from DK_PTN where NgayDK='{ngay}'"))
{
MessageBox.Show("Có Lỗi !");
}
else
{
MessageBox.Show("Thành công !");
}
SqlConnection sql = DBUtils.GetDBConnection();
sql.Open();
SqlCommand cm = new SqlCommand("select * from DK_PTN", sql);
SqlDataAdapter adap = new SqlDataAdapter(cm);
DataTable dt = new DataTable();
adap.Fill(dt);
dataGridView2.DataSource = dt;
sql.Close();
}
}
private void US_dkPTN_Load(object sender, EventArgs e)
{
//-----------load nhom
SqlConnection sql = DBUtils.GetDBConnection();
sql.Open();
SqlCommand cm = new SqlCommand("select MaNhom,TenNhom from NhomSV", sql);
SqlDataAdapter adap = new SqlDataAdapter(cm);
DataTable dt = new DataTable();
adap.Fill(dt);
cbTenNhom.DisplayMember = "TenNhom";
cbTenNhom.ValueMember = "MaNhom";
cbTenNhom.DataSource = dt;
//-----------load loại TN
cm = new SqlCommand("select MaLoaiTN,TenLoai from Loai_TN", sql);
adap = new SqlDataAdapter(cm);
dt = new DataTable();
adap.Fill(dt);
cbLoaiTN.DisplayMember = "TenLoai";
cbLoaiTN.ValueMember = "MaLoaiTN";
cbLoaiTN.DataSource = dt;
//-----------load loại TN
cm = new SqlCommand("select MaPTN,TenPTN from PhongThiNghiem", sql);
adap = new SqlDataAdapter(cm);
dt = new DataTable();
adap.Fill(dt);
cbTenPhong.DisplayMember = "MaPTN";
cbTenPhong.ValueMember = "MaPTN";
cbTenPhong.DataSource = dt;
//-------------------GVQL
cm = new SqlCommand("select MaGVQL,TenGVQL from GV_QLTN", sql);
adap = new SqlDataAdapter(cm);
dt = new DataTable();
adap.Fill(dt);
cbTenGV.DisplayMember = "MaGVQL";
cbTenGV.ValueMember = "MaGVQL";
cbTenGV.DataSource = dt;
//---------------------Buổi
cm = new SqlCommand("select MaBuoi,Tiet from Buoi", sql);
adap = new SqlDataAdapter(cm);
dt = new DataTable();
adap.Fill(dt);
cbBuoi.DisplayMember = "MaBuoi";
cbBuoi.ValueMember = "MaBuoi";
cbBuoi.DataSource = dt;
//-------------------grid TB
cm = new SqlCommand("select MaTB,TenTB from ThietBi", sql);
adap = new SqlDataAdapter(cm);
dt = new DataTable();
adap.Fill(dt);
dataGridView_ThietBi.DataSource = dt;
cm = new SqlCommand("select * from ThietBi", sql);
adap = new SqlDataAdapter(cm);
dt = new DataTable();
adap.Fill(dt);
dataGridView_ThietBi.DataSource = dt;
cm = new SqlCommand("select * from DK_PTN", sql);
adap = new SqlDataAdapter(cm);
dt = new DataTable();
adap.Fill(dt);
dataGridView2.DataSource = dt;
sql.Close();
txtMaTB.Enabled = false;
btnLuu.Enabled = false;
sql.Close();
}