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