private void btnXoa_Click(object sender, EventArgs e)
{
DialogResult key = MessageBox.Show("Bạn có muốn xóa không?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (key == DialogResult.Yes)
{
try
{
string sql = "DELETE KHOA where MaKhoa = '" + tbMaKhoa.Text.ToString() + "'";
csdl csdl = new csdl();
csdl.Them(sql);
csdl.KetNoi();
string khoa = "select * from Khoa ";
dtgKhoa.DataSource = csdl.GetData(khoa);
cboKhoa2.DataSource = csdl.GetData(khoa);
cboKhoa2.DisplayMember = "TenKhoa";
cboKhoa2.ValueMember = "MaKhoa";
cboKhoa3.DataSource = csdl.GetData(khoa);
cboKhoa3.DisplayMember = "TenKhoa";
cboKhoa3.ValueMember = "MaKhoa";
}
catch (Exception LOI)
{
MessageBox.Show(LOI.Message, "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void btnCapNhap3_Click(object sender, EventArgs e)
{
{
DialogResult key = MessageBox.Show("Bạn có muốn cập nhật không?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (key == DialogResult.Yes)
{
try
{
string sql = "update SINHVIEN set MaLop = N'" + cboLop1.SelectedValue.ToString() +
"', TenSV =N' " + tbHoTen3.Text.ToString() + "',GioiTinh = N'" + (radioButton1.Checked == true ? "True" : "False") +
"',NgaySinh = N'" + dateTimePicker1.Value.ToString("yyyy/MM/dd") + "',SDT = N'" + tbSDT3.Text.ToString()
+ "' where MaSV = '" + dtgSinhVien[0, dtgSinhVien.CurrentRow.Index].Value.ToString() + "'";
csdl csdl = new csdl();
csdl.Them(sql);
csdl.KetNoi();
string sinhvien = "select * from SINHVIEN where MaLop = " + "'" + cboLop1.SelectedValue.ToString() + "'";
dtgSinhVien.DataSource = csdl.GetData(sinhvien);
}
catch (Exception LOI)
{
MessageBox.Show(LOI.Message, "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
private void btnCapNhap2_Click(object sender, EventArgs e)
{
DialogResult key = MessageBox.Show("Bạn có muốn cập nhập không?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (key == DialogResult.Yes)
{
try
{
string sql = "UPDATE LOP set SiSo = N'"
+ tbSiSo2.Text.ToString() +
"', MaKhoa =N'" + cboKhoa2.SelectedValue.ToString()
+ "',TenLop= N'" + tbKhoaL2.Text.ToString() + tbLop2.Text.ToString() + " " + tbNganh2.Text.ToString()
+ "'where MaLop = '" + dtgLop[0, dtgLop.CurrentRow.Index].Value.ToString() + "'";
csdl csdl = new csdl();
csdl.Them(sql);
csdl.KetNoi();
string lop = "select * from LOP where MaKhoa = " + "'" + cboKhoa2.SelectedValue.ToString() + "'";
dtgLop.DataSource = csdl.GetData(lop);
}
catch (Exception LOI)
{
MessageBox.Show(LOI.Message, "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void btnCapNhap_Click(object sender, EventArgs e)
{
DialogResult key = MessageBox.Show("Bạn có muốn cập nhập không?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (key == DialogResult.Yes)
{
try
{
//SqlConnection cn = new SqlConnection("Data Source=AME\\SQLEXPRESS;Initial Catalog=QuanLySinhVien;Integrated Security=True");
//string sql = "insert into KHOA values(N'" + textBox1.Text.ToString() + "', N'" + textBox2.Text.ToString() + "', " + textBox3.Text.ToString() + ")";
//SqlCommand cmd = new SqlCommand(sql, cn);
//cmd.CommandType = CommandType.Text;
//cn.Open();
//cmd.ExecuteNonQuery();
//cn.Close();
//cn.Dispose();
string khoa = "select * from KHOA";
csdl csdl = new csdl();
string sql = "UPDATE KHOA set TenKhoa = N'" + tbTenKhoa.Text.ToString() + "', SDT = N' " + tbSDT.Text.ToString() + "' WHERE MaKhoa = N'" + tbMaKhoa.Text.ToString() + "'";
csdl.Them(sql);
csdl.KetNoi();
dtgKhoa.DataSource = csdl.GetData(khoa);
}
catch (Exception LOI)
{
MessageBox.Show(LOI.Message, "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void Button8_Click(object sender, EventArgs e)
{
{
DialogResult key = MessageBox.Show("Bạn có muốn lưu không?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (key == DialogResult.Yes)
{
try
{
StreamReader sr = new StreamReader("data.txt");
string maSV = sr.ReadLine();
sr.Close();
int maSV1 = 1 + int.Parse(maSV);
StreamWriter sw = new StreamWriter("data.txt");
sw.Write(maSV1);
sw.Close();
string sql = "insert into SINHVIEN values(N'" + maSV1.ToString() + "', N'" + cboLop1.SelectedValue.ToString() +
"',N' " + tbHoTen3.Text.ToString() + "', N'" + (radioButton1.Checked == true ? "True":"False") +
"', N'" + dateTimePicker1.Value.ToString("yyyy/MM/dd") + "', N'" + tbSDT3.Text.ToString() + "')";
csdl csdl = new csdl();
csdl.Them(sql);
csdl.KetNoi();
string sinhvien = "select * from SINHVIEN where MaLop = " + "'" + cboLop1.SelectedValue.ToString() + "'";
dtgSinhVien.DataSource = csdl.GetData(sinhvien);
}
catch (Exception LOI)
{
MessageBox.Show(LOI.Message, "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
private void Button5_Click(object sender, EventArgs e)
{
{
DialogResult key = MessageBox.Show("Bạn có muốn lưu không?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (key == DialogResult.Yes)
{
try
{
string[] s;
s = tbNganh2.Text.ToString().Split(' ');
string c = null;
for (int i = 0; i < s.Length; i++)
{
c = c + s[i].Substring(0, 1);
}
string d = tbKhoaL2.Text.ToString() + tbLop2.Text.ToString() + c.ToUpper();
string sql = "insert into LOP values(N'" + d + "', N'" + cboKhoa2.SelectedValue.ToString() + "', N'" + tbKhoaL2.Text.ToString() + tbLop2.Text.ToString() + " " + tbNganh2.Text.ToString() + "', N'" + tbSiSo2.Text.ToString() + "')";
csdl csdl = new csdl();
csdl.Them(sql);
csdl.KetNoi();
string lop = "select * from LOP where MaKhoa = " + "'" + cboKhoa2.SelectedValue.ToString() + "'";
dtgLop.DataSource = csdl.GetData(lop);
}
catch (Exception LOI)
{
MessageBox.Show(LOI.Message, "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
private void btnXoa2_Click(object sender, EventArgs e)
{
DialogResult key = MessageBox.Show("Bạn có muốn xóa không?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (key == DialogResult.Yes)
{
try
{
string sql = "DELETE LOP where MaLop = '" + dtgLop[0, dtgLop.CurrentRow.Index].Value.ToString() + "'";
csdl csdl = new csdl();
csdl.Them(sql);
csdl.KetNoi();
string lop = "select * from LOP where MaKhoa = " + "'" + cboKhoa2.SelectedValue.ToString() + "'";
dtgLop.DataSource = csdl.GetData(lop);
}
catch (Exception LOI)
{
MessageBox.Show(LOI.Message, "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
