private void QuanLyDocGia_Load(object sender, EventArgs e) { tv.connect(); string sql = "Select*from Docgia"; dgrQuanlydocgia.DataSource = tv.Taobang(sql); Xoa(); tv.disconnect(); }
private void Thongke_Load(object sender, EventArgs e) { tv.connect(); string sql = "select * from Theloai"; cmbMatheloai.DataSource = tv.Taobang(sql); cmbMatheloai.DisplayMember = "MaTheLoai"; dgrThongke.DataSource = tv.Taobang("select * from Sach"); tv.disconnect(); }
private void QuanlyThe_Load(object sender, EventArgs e) { tv.connect(); string sql1 = "select*from The"; dgrQuanlythe.DataSource = tv.Taobang(sql1); tv.disconnect(); //hien thi ma sinh vien cmbMaSV.DataSource = CapMathe(); cmbMaSV.DisplayMember = "MaSV"; }
public static DataTable TenNXB() { string sql = "select TenNXB from Nhaxuatban"; Ketnoi db = new Ketnoi(); DataTable ds; ds = db.Taobang(sql); return(ds); }
public static DataTable TenTheLoai() { string sql = "select TenTheLoai from Theloai"; Ketnoi db = new Ketnoi(); DataTable ds; ds = db.Taobang(sql); return(ds); }
public static DataTable CapMathe() { string sql = "select MaSV from DOCGIA"; Ketnoi db = new Ketnoi(); DataTable dt; dt = db.Taobang(sql); return(dt); }
public static DataTable NgayHenTra() { string sql = "select NgayTra from Chitietphieumuon"; Ketnoi db = new Ketnoi(); DataTable ds; ds = db.Taobang(sql); return(ds); }
public static DataTable TenSach() { string sql = "select TenSach from Sach"; Ketnoi db = new Ketnoi(); DataTable ds; ds = db.Taobang(sql); return(ds); }
public static DataTable MaSV() { string sql = "select MaSV from The"; Ketnoi db = new Ketnoi(); DataTable ds; ds = db.Taobang(sql); return(ds); }
public static DataTable MatheMuon() { string sql = "select DISTINCT MaThe from Chitietphieumuon"; Ketnoi db = new Ketnoi(); DataTable ds; ds = db.Taobang(sql); return(ds); }
public static DataTable Sophieu() { string sql = "select DISTINCT SoPhieu from Chitietphieumuon"; Ketnoi db = new Ketnoi(); DataTable ds; ds = db.Taobang(sql); return(ds); }
private void QuanlySach_Load(object sender, EventArgs e) { cmbTinhtrangsach.Items.Add("Tốt"); cmbTinhtrangsach.Items.Add("Xấu"); cmbTinhtrangsach.Items.Add("Bình thường"); cmbTinhtrangsach.SelectedItem = "Tốt"; cmbNgonngu.SelectedItem = "Tiếng việt"; string sql1 = "select * from Sach"; dgrThongtin.DataSource = tv.Taobang(sql1); Xoasach(); string sql2 = "select * from Theloai"; dgrTheloai.DataSource = tv.Taobang(sql2); XoaTheloai(); string sql3 = "select * from Nhaxuatban"; dgrNhaxuatban.DataSource = tv.Taobang(sql3); XoaNXB(); cmbTenNXB.DataSource = TenNXB(); cmbTenNXB.DisplayMember = "TenNXB"; cmbTentheloai.DataSource = TenTheLoai(); cmbTentheloai.DisplayMember = "Tentheloai"; }
private void Hienthi() { string sql = "select *from Chitietphieumuon"; dgrMuonsach.DataSource = tv.Taobang(sql); }