private void btnSua_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(); con.ConnectionString = KetNoi.str; con.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = con; double DiemThi; DiemThi = Convert.ToDouble(txtDiemThi.Text); double TongKet; TongKet = Convert.ToDouble(txtDiemTongKet.Text); cmd.CommandText = "UPDATE KetQua SET DiemThi=" + DiemThi + ",DiemTongKet=" + TongKet + " WHERE ID_SinhVien='" + SinhVien_ID + "' AND ID_MonHoc='" + MonHoc_ID + "' AND LanThi=" + LanThi + ""; DialogResult result; result = MessageBox.Show("BẠN CÓ MUỐN THAY ĐỔI THÔNG TIN KHÔNG?", "THÔNG BÁO", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { cmd.ExecuteNonQuery(); con.Close(); MessageBox.Show("CẬP NHẬT THÀNH CÔNG", "THÔNG BÁO"); } this.Close(); frmKetQuaHocTap frm = new frmKetQuaHocTap(SinhVien_ID); frm.Show(); }
private void btnThoat_Click(object sender, EventArgs e) { this.Close(); frmKetQuaHocTap frm = new frmKetQuaHocTap(SinhVien_ID); frm.Show(); }
private void btnXoa_Click(object sender, EventArgs e) { int LanThi; string MonHoc_ID; string TenMonHoc; int row; row = this.listView1.SelectedItems[0].Index; LanThi = Convert.ToInt16(this.listView1.Items[row].SubItems[2].Text); TenMonHoc = this.listView1.Items[row].SubItems[0].Text; SqlConnection con = new SqlConnection(); con.ConnectionString = KetNoi.str; con.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandText = "SELECT MonHoc_ID FROM MonHoc WHERE TenMonHoc='" + TenMonHoc + "' "; SqlDataReader rd; rd = cmd.ExecuteReader(); DataTable td = new DataTable(); td.Load(rd); MonHoc_ID = td.Rows[0][0].ToString(); cmd.CommandText = "DELETE FROM KetQua WHERE ID_SinhVien='" + SinhVien_ID + "' AND ID_MonHoc='" + MonHoc_ID + "' AND LanThi=" + LanThi + " "; DialogResult result; result = MessageBox.Show("BẠN CÓ MUỐN XOÁ KẾT QUẢ KHÔNG?", "THÔNG BÁO", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { cmd.ExecuteNonQuery(); con.Close(); MessageBox.Show("XÓA THÀNH CÔNG", "THÔNG BÁO"); this.Close(); frmKetQuaHocTap frm = new frmKetQuaHocTap(SinhVien_ID); frm.Show(); } }
private void btnThem_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(); con.ConnectionString = KetNoi.str; con.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = con; string TenMonHoc; TenMonHoc = cboMonHoc.SelectedItem.ToString(); cmd.CommandText = "select* from MonHoc where TenMonHoc ='" + TenMonHoc + "'"; SqlDataReader rd; rd = cmd.ExecuteReader(); DataTable td = new DataTable(); td.Load(rd); string MaMonHoc = td.Rows[0][0].ToString(); int LanThi; LanThi = Convert.ToInt16(txtLanThi.Text); double DiemThi; DiemThi = Convert.ToDouble(txtDiemThi.Text); double TongKet; TongKet = Convert.ToDouble(txtDiemTongKet.Text); cmd.CommandText = "INSERT INTO KetQua VALUES('" + MaMonHoc + "','" + SinhVien_ID + "'," + LanThi + "," + DiemThi + "," + TongKet + ")"; cmd.ExecuteNonQuery(); con.Close(); MessageBox.Show("Thêm Dữ Liệu Thành Công!"); this.Close(); frmKetQuaHocTap frm = new frmKetQuaHocTap(SinhVien_ID); frm.Show(); }
private void button1_Click(object sender, EventArgs e) { frmKetQuaHocTap frm = new frmKetQuaHocTap(SinhVien_ID); frm.Show(); }