private void hien() { string sql = @"select *from TaiKhoan"; dtgvtaikhoan.DataSource = KetNoi.getTable(sql); binding(); }
private void NhuCauMuonSach_Load(object sender, EventArgs e) { string sql = @"SELECT * FROM Sach"; cmbsach.DataSource = KetNoi.getTable(sql); cmbsach.DisplayMember = "TenSach"; cmbsach.ValueMember = "MaSach"; string sql1 = @"SELECT * FROM DocGia"; cmbdocgia.DataSource = KetNoi.getTable(sql1); cmbdocgia.DisplayMember = "TenDocGia"; cmbdocgia.ValueMember = "MaDocGia"; string sql2 = @"SELECT * FROM NhanVien"; cmbnhanvien.DataSource = KetNoi.getTable(sql2); cmbnhanvien.DisplayMember = "TenNV"; cmbnhanvien.ValueMember = "MaNV"; mobtn(); dongtxt(); hien(); }
private void hien() { string sql = @"select MaSach,TenSach,S.MaTheLoai,TheLoai.TenTheLoai,S.MaTG,TacGia.TenTG,NXB,NamXB,GiaTien,SoTrang,TinhTrangSach,SoLuong from Sach S inner join TheLoai on S.MaTheLoai=TheLoai.MaTheLoai inner join TacGia ON S.MaTG=TacGia.MaTG"; dtgvsach.DataSource = KetNoi.getTable(sql); }
private void hien() { string sql = @"select STT,SoPM,Sach.MaSach,Sach.TenSach,SoLuongSachMuon,DocGia.MaDocGia,DocGia.TenDocGia,NgayMuon,NgayHanTra,TinhTrangSach,GhiChu, NhanVien.MaNV, TenNV from NhuCau inner join Sach on Sach.MaSach=NhuCau.MaSach inner join DocGia on DocGia.MaDocGia=NhuCau.MaDocGia inner join NhanVien on NhanVien.MaNV=NhuCau.MaNV"; dtgv2.DataSource = KetNoi.getTable(sql); }
private void bttim_Click(object sender, EventArgs e) { string sql = @"select* from TacGia"; DataTable data = KetNoi.getTable(sql); //lấy dữ liệu từ bảng KhachHang if (txttim.Text != "") { data.DefaultView.RowFilter = "TenTG LIKE '%" + txttim.Text + "%' or DiaChiTG LIKE '%" + txttim.Text + "%' "; //filter lọc dữ liệu } else { data.DefaultView.RowFilter = ""; } dtgvtacgia.DataSource = data; }
private void bttim_Click(object sender, EventArgs e) { string sql = @"select* from TheLoai"; DataTable data = KetNoi.getTable(sql); //lấy dữ liệu từ bảng Thể loại if (txttim.Text != "") { data.DefaultView.RowFilter = "TenTheLoai LIKE '%" + txttim.Text + "%' "; //filter lọc dữ liệu } else { data.DefaultView.RowFilter = ""; } dtgvtheloai.DataSource = data; }
private void bttim_Click(object sender, EventArgs e) { string sql = @"select* from NhanVien"; DataTable data = KetNoi.getTable(sql); //lấy dữ liệu từ bảng Nhân viên if (txttim.Text != "") { data.DefaultView.RowFilter = "TenNV LIKE '%" + txttim.Text + "%' or DiaChi LIKE '%" + txttim.Text + "%' or GioiTinh LIKE '%" + txttim.Text + "%' "; //filter lọc dữ liệu } else { data.DefaultView.RowFilter = ""; } dtgvnhanvien.DataSource = data; }
private void bttimkiem_Click(object sender, EventArgs e) { string sql = @"select MaSach,TenSach,S.MaTheLoai,S.MaTG,NXB,NamXB,GiaTien,SoTrang,TinhTrangSach,TheLoai.TenTheLoai,TacGia.TenTG,SoLuong from Sach S inner join TheLoai on S.MaTheLoai=TheLoai.MaTheLoai inner join TacGia ON S.MaTG=TacGia.MaTG"; DataTable data = KetNoi.getTable(sql); //lấy dữ liệu từ bảng KhachHang if (txttim.Text != "") { data.DefaultView.RowFilter = "TenSach LIKE '%" + txttim.Text + "%' or NXB LIKE '%" + txttim.Text + "%' or TenTG LIKE '%" + txttim.Text + "%' or TenTheLoai LIKE '%" + txttim.Text + "%'"; //filter lọc dữ liệu } else { data.DefaultView.RowFilter = ""; } dtgvsach.DataSource = data; //gán giá trị vào datagridview }
private void bttimkiem_Click(object sender, EventArgs e) { string sql = @"select STT, SoPM,Sach.MaSach,Sach.TenSach,SoLuongSachMuon,DocGia.MaDocGia,DocGia.TenDocGia,NgayMuon,NgayHanTra,TinhTrangSach,GhiChu, NhanVien.MaNV, TenNV from NhuCau inner join Sach on Sach.MaSach=NhuCau.MaSach inner join DocGia on DocGia.MaDocGia=NhuCau.MaDocGia inner join NhanVien on NhanVien.MaNV=NhuCau.MaNV"; DataTable data = KetNoi.getTable(sql); //lấy dữ liệu từ bảng KhachHang if (txttim.Text != "") { data.DefaultView.RowFilter = "TenDocGia LIKE '%" + txttim.Text + "%' OR TenNV LIKE '%" + txttim.Text + "%' OR TenSach LIKE '%" + txttim.Text + "%'"; //filter lọc dữ liệu } else { data.DefaultView.RowFilter = ""; } dtgv2.DataSource = data; //gán giá trị vào datagridview }
private void Sach_Load(object sender, EventArgs e) { string sql = @"SELECT * FROM TheLoai"; cmbMaTL.DataSource = KetNoi.getTable(sql); cmbMaTL.DisplayMember = "TenTheLoai"; cmbMaTL.ValueMember = "MaTheLoai"; string sql1 = @"SELECT * FROM TacGia"; cmbMaTG.DataSource = KetNoi.getTable(sql1); cmbMaTG.DisplayMember = "TenTG"; cmbMaTG.ValueMember = "MaTG"; mobtn(); dongtxt(); hien(); }
private void hien() { string sql = @"select *from TacGia"; dtgvtacgia.DataSource = KetNoi.getTable(sql); }
private void hien() { string sql = @"select *from TheLoai"; dtgvtheloai.DataSource = KetNoi.getTable(sql); }
private void hien() { string sql = @"select *from NhanVien"; dtgvnhanvien.DataSource = KetNoi.getTable(sql); }