Esempio n. 1
0
        private void btnThoat_Click(object sender, EventArgs e)
        {
            this.Close();
            frmDSLop frm = new frmDSLop(Khoa_ID);

            frm.Show();
        }
Esempio n. 2
0
        private void btnDSLop_Click(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection();

            con.ConnectionString = KetNoi.str;
            con.Open();
            SqlCommand cmd = new SqlCommand();

            cmd.Connection = con;
            string TenKhoa;

            TenKhoa         = cboDSKhoa.SelectedItem.ToString();
            cmd.CommandText = "SELECT Khoa_ID FROM Khoa WHERE TenKhoa='" + TenKhoa + "'";
            SqlDataReader rd;

            rd = cmd.ExecuteReader();
            DataTable td = new DataTable();

            td.Load(rd);
            string MaKhoa;

            MaKhoa = td.Rows[0][0].ToString();

            con.Close();
            this.Close();
            frmDSLop frmDS = new frmDSLop(MaKhoa);

            frmDS.Show();
        }
Esempio n. 3
0
        private void btnXoa_Click(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection();

            con.ConnectionString = KetNoi.str;
            con.Open();
            SqlCommand cmd  = new SqlCommand();
            SqlCommand cmd1 = new SqlCommand();
            SqlCommand cmd2 = new SqlCommand();
            SqlCommand cmd3 = new SqlCommand();

            cmd.Connection   = con;
            cmd1.Connection  = con;
            cmd2.Connection  = con;
            cmd3.Connection  = con;
            cmd1.CommandText = "SELECT SinhVien_ID FROM SinhVien WHERE ID_Lop='" + MaLop + "'";
            SqlDataReader rd;

            rd = cmd1.ExecuteReader();
            DataTable td = new DataTable();

            td.Load(rd);
            string MaSinhVien;

            if (td.Rows.Count == 0)
            {
                MaSinhVien = "";
            }
            else
            {
                MaSinhVien = td.Rows[0][0].ToString();
            }
            cmd2.CommandText = "DELETE FROM KetQua WHERE ID_SinhVien='" + MaSinhVien + "' ";
            cmd3.CommandText = "DELETE FROM SinhVien WHERE SinhVien_ID='" + MaSinhVien + "' AND ID_Lop='" + MaLop + "'";
            cmd.CommandText  = "DELETE FROM Lop WHere Lop_ID='" + MaLop + "'";
            DialogResult result;

            result = MessageBox.Show("BẠN CÓ MUỐN XOÁ DỮ LIỆU KHÔNG?", "Thông Báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
            if (result == DialogResult.Yes)
            {
                cmd2.ExecuteNonQuery();
                cmd3.ExecuteNonQuery();
                cmd.ExecuteNonQuery();
                con.Close();
                MessageBox.Show("DỮ LIỆU ĐÃ ĐƯỢC XOÁ", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                this.Close();
                frmDSLop frm = new frmDSLop(Khoa_ID);
                frm.Show();
            }
        }
Esempio n. 4
0
        private void button1_Click(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection();

            con.ConnectionString = KetNoi.str;
            con.Open();
            SqlCommand cmd = new SqlCommand();

            cmd.Connection = con;
            string TenKhoa;

            TenKhoa         = cboKhoa.SelectedItem.ToString();
            cmd.CommandText = "SELECT Khoa_ID FROM Khoa WHERE TenKhoa='" + TenKhoa + "'";
            SqlDataReader rd;

            rd = cmd.ExecuteReader();
            DataTable td = new DataTable();

            td.Load(rd);
            string MaKhoa;

            MaKhoa          = td.Rows[0][0].ToString();
            cmd.CommandText = "UPDATE Lop SET TenLop='" + txtTenLop.Text + "',ID_Khoa='" + MaKhoa + "' WHERE Lop_ID='" + MaLop + "'";
            DialogResult result;

            result = MessageBox.Show("BẠN CÓ MUỐN SỬA LẠI DỮ LIỆU KHÔNG?", "Thông Báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
            if (result == DialogResult.Yes)
            {
                cmd.ExecuteNonQuery();
                con.Close();
                MessageBox.Show("SỬA DỮ LIỆU THÀNH CÔNG");
                this.Close();
                frmDSLop frm = new frmDSLop(Khoa_ID);
                frm.Show();
            }
        }