private void FormThemLopHoc_Load(object sender, EventArgs e) { CSDL csdl = new CSDL(); // ma MHP string getAllMaMHP = "SELECT MaMHP FROM MUCHOCPHI"; DataTable maMHPTable = csdl.SelectData(getAllMaMHP); comboBoxMaMHP.DataSource = maMHPTable.Copy(); comboBoxMaMHP.DisplayMember = "MaMHP"; comboBoxMaMHP.ValueMember = "MaMHP"; //ma mon học string getAllMaMH = "SELECT MaMH FROM MONHOC"; DataTable maMHTable = csdl.SelectData(getAllMaMH); comboBoxMaMonHoc.DataSource = maMHTable.Copy(); comboBoxMaMonHoc.DisplayMember = "MaMH"; comboBoxMaMonHoc.ValueMember = "MaMH"; // mã giáo viên string getAllMaGV = "SELECT MaGV FROM GIAOVIEN"; DataTable maGVTable = csdl.SelectData(getAllMaGV); comboBoxMaGiaoVien.DataSource = maGVTable.Copy(); comboBoxMaGiaoVien.DisplayMember = "MaGV"; comboBoxMaGiaoVien.ValueMember = "MaGV"; if (string.IsNullOrEmpty(malh)) { this.Text = "Thêm mới lớp học"; } else { this.Text = "Cập nhật thông tin lớp học"; var r = new CSDL().Select(string.Format("searchMaLop '" + malh + "'")); textBoxMaLop.Text = r["MaLH"].ToString(); textBoxMaLop.ReadOnly = true; textBoxTenLop.Text = r["TenLH"].ToString(); string maMucHocPhi = r["MaMHP"].ToString(); Console.WriteLine(maMucHocPhi); comboBoxMaMHP.SelectedValue = maMucHocPhi; string maMonHoc = r["MaMH"].ToString(); comboBoxMaMHP.SelectedValue = maMonHoc; string maGiaoVien = r["MaGV"].ToString(); comboBoxMaMHP.SelectedValue = maGiaoVien; } }
private void btnSearch_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(textBox1.Text)) { MessageBox.Show("Bạn chưa nhập thông tin tìm kiếm", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { if (comboBoxSearch.SelectedIndex != -1) { String valueSearch = textBox1.Text; var db = new CSDL(); String sqlSearch = ""; if (comboBoxSearch.SelectedIndex == 0) { sqlSearch = "exec searchMaLop '" + valueSearch + "'"; if (db.SelectData(sqlSearch).Rows.Count != 0) { new SearchOutLH(sqlSearch).Show(); } else { MessageBox.Show("Không tìm thấy thông tin", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else if (comboBoxSearch.SelectedIndex == 1) { sqlSearch = "exec searchTenLop N'" + valueSearch + "'"; if (db.SelectData(sqlSearch).Rows.Count != 0) { new SearchOutLH(sqlSearch).Show(); } else { MessageBox.Show("Không tìm thấy thông tin", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } resetValue(); } }
private void FormQLDD_Load(object sender, EventArgs e) { CSDL csdl = new CSDL(); string getAllMaLH = "SELECT MaLH FROM LOPHOC"; DataTable maLHTable = csdl.SelectData(getAllMaLH); comboBoxChonLop.DataSource = maLHTable.Copy(); comboBoxChonLop.DisplayMember = "MaLH"; comboBoxChonLop.ValueMember = "MaLH"; comboBoxChonLop.SelectedIndex = 7; comboBoxChonThang.SelectedIndex = 8; }