private void BtnOK_Click(object sender, EventArgs e)
{
bus.update(txtngay.Text);
string show = "select bc2.masach, bc2.tensach, bc2.ngaymuon, songaytratre from BaoCaoII bc2, PhieuMuonSach pms where bc2.masach = pms.masach";
db.LoadData2DataGridView(dataGridView1, show);
}
private void Button1_Click(object sender, EventArgs e)
{
if (bus.Check(cbThang.Text).Rows.Count > 0)
{
string show = "select theloai as 'Thể loại', count (*) as 'Số lượt mượn', count(*) * 100.0 / sum(count(*)) over() as 'Tỷ lệ' " +
"from BaoCaoI where thang = '" + cbThang.Text + "' group by theloai";
db.LoadData2DataGridView(dgvBaoCaoI, show);
MessageBox.Show("Thành công");
}
else
{
MessageBox.Show("Thất bại");
}
}