private void frmReportBookInfo_Load(object sender, EventArgs e)
{
DataSetBookInfo ds = new DataSetBookInfo();
DataSetBookInfoTableAdapters.BookInfoTableAdapter dst = new DataSetBookInfoTableAdapters.BookInfoTableAdapter();
dst.Fill(ds.BookInfo);
CrystalReportBookInfo cr = new CrystalReportBookInfo();
cr.SetDataSource(ds);
crystalReportViewer.ReportSource = cr;
}
private void btnPrint_Click(object sender, EventArgs e)
{
DataSetBookInfo ds = new DataSetBookInfo();
DataSetBookInfoTableAdapters.ReceiptTableAdapter adapter = new DataSetBookInfoTableAdapters.ReceiptTableAdapter();
adapter.Fill(ds.Receipt);
CrystalReportBorrowingBookInfo cr = new CrystalReportBorrowingBookInfo();
var aa = ds.Receipt.Where(x => x.TransactionID == transactionID && x.MemberID == memberID && bookList.Contains(x.BookID)).ToList();
cr.SetDataSource(ds.Receipt.Where(x => x.TransactionID == transactionID && x.MemberID == memberID && bookList.Contains(x.BookID))
.Select(x => new { MemberID = x.MemberID, BookID = x.BookID, BookTitle = x.BookTitle, Author = x.Author, BookType = x.BookType, DateIssue = x.DateIssue, DateDue = x.DateDue }).ToList());
frmReportBorrowingBookInfo viewer = new frmReportBorrowingBookInfo(cr);
viewer.Show();
}
private void frmReportPopularBook_Load(object sender, EventArgs e)
{
DataSetBookInfo ds = new DataSetBookInfo();
DataSetBookInfoTableAdapters.PopularbookTableAdapter ta = new DataSetBookInfoTableAdapters.PopularbookTableAdapter();
ta.Fill(ds.Popularbook);
CrystalReportPopularbook cr = new CrystalReportPopularbook();
cr.SetDataSource(ds);
crystalReportViewer1.ReportSource = cr;
//.popular6TableAdapter ta = new DataSetpopularbookTableAdapters.popular6TableAdapter();
//ta.Fill(ds.popular6);
//CrystalReportpopularbook cr = new CrystalReportpopularbook();
////CrystalReportpopularbook1 cr = new CrystalReportpopularbook1();
//cr.SetDataSource(ds);
//crystalReportViewer1.ReportSource = cr;
}
