/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.ReportViewer = new CrystalDecisions.Windows.Forms.CrystalReportViewer();
this.rptTKDGMuon1 = new Quanlythuvien.rptTKDGMuon();
this.SuspendLayout();
//
// ReportViewer
//
this.ReportViewer.ActiveViewIndex = -1;
this.ReportViewer.DisplayGroupTree = false;
this.ReportViewer.Location = new System.Drawing.Point(0, 0);
this.ReportViewer.Name = "ReportViewer";
this.ReportViewer.ReportSource = null;
this.ReportViewer.Size = new System.Drawing.Size(800, 600);
this.ReportViewer.TabIndex = 0;
//
// rptTKDGMuon1
//
this.rptTKDGMuon1.PrintOptions.PaperOrientation = CrystalDecisions.Shared.PaperOrientation.DefaultPaperOrientation;
this.rptTKDGMuon1.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.DefaultPaperSize;
this.rptTKDGMuon1.PrintOptions.PaperSource = CrystalDecisions.Shared.PaperSource.Upper;
this.rptTKDGMuon1.PrintOptions.PrinterDuplex = CrystalDecisions.Shared.PrinterDuplex.Default;
//
// frmRptTKDGMuon
//
this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
this.ClientSize = new System.Drawing.Size(792, 566);
this.Controls.Add(this.ReportViewer);
this.Name = "frmRptTKDGMuon";
this.Text = "frmRptTKDGMuon";
this.Load += new System.EventHandler(this.frmRptTKDGMuon_Load);
this.ResumeLayout(false);
}
private void frmRptTKDGMuon_Load(object sender, System.EventArgs e)
{
dtTKDG myDataSet = new dtTKDG();
string sql = "select * from docgia";
SqlConnection con = new SqlConnection(SqlHelper.ConnectString);
SqlDataAdapter adapter = new SqlDataAdapter(sql, con);
adapter.Fill(myDataSet, "docgia");
sql = "select * from muonsach where ngaymuon>='" +
SqlHelper.dTuNgay + "' and ngaymuon<='" + SqlHelper.dDenNgay + "'";
con = new SqlConnection(SqlHelper.ConnectString);
adapter = new SqlDataAdapter(sql, con);
adapter.Fill(myDataSet, "muonsach");
rptTKDGMuon1 = new rptTKDGMuon();
rptTKDGMuon1.SetDataSource(myDataSet);
ReportViewer.ReportSource = rptTKDGMuon1;
}