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);
}
