private void frmRptSachMuon_Load(object sender, System.EventArgs e)
{
dtMuonSach myDataSet = new dtMuonSach();
string sql = "select * from docgia";
SqlConnection con = new SqlConnection(SqlHelper.ConnectString);
SqlDataAdapter adapter = new SqlDataAdapter(sql, con);
adapter.Fill(myDataSet, "docgia");
sql = "select * from quyensach";
con = new SqlConnection(SqlHelper.ConnectString);
adapter = new SqlDataAdapter(sql, con);
adapter.Fill(myDataSet, "quyensach");
sql = "select * from muonsach";
con = new SqlConnection(SqlHelper.ConnectString);
adapter = new SqlDataAdapter(sql, con);
adapter.Fill(myDataSet, "muonsach");
sql = "select * from chitietphieumuon";
con = new SqlConnection(SqlHelper.ConnectString);
adapter = new SqlDataAdapter(sql, con);
adapter.Fill(myDataSet, "chitietphieumuon");
/*string sql="select * from docgia";
* oleDbConnection1.ConnectionString=SqlHelper.ConnectString;
* oleDbDataAdapter1=new System.Data.OleDb.OleDbDataAdapter(sql,oleDbConnection1);
*
* oleDbDataAdapter1.Fill(myDataSet,"docgia");
*
* sql="select * from quyensach";
* oleDbDataAdapter1=new System.Data.OleDb.OleDbDataAdapter(sql,oleDbConnection1);
* oleDbDataAdapter1.Fill(myDataSet,"quyensach");
*
* sql="select * from muonsach";
* oleDbDataAdapter1=new System.Data.OleDb.OleDbDataAdapter(sql,oleDbConnection1);
* oleDbDataAdapter1.Fill(myDataSet,"muonsach");
*
*
* sql="select * from chitietphieumuon";
* oleDbDataAdapter1=new System.Data.OleDb.OleDbDataAdapter(sql,oleDbConnection1);
*
* oleDbDataAdapter1.Fill(myDataSet,"chitietphieumuon");
*
*/
rptSachMuon1 = new rptMuonSach();
rptSachMuon1.SetDataSource(myDataSet);
ReportViewer.ReportSource = rptSachMuon1;
}
/// <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.rptSachMuon1 = new Quanlythuvien.rptMuonSach();
this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();
this.SuspendLayout();
//
// ReportViewer
//
this.ReportViewer.ActiveViewIndex = -1;
this.ReportViewer.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom)
| System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));
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;
this.ReportViewer.Load += new System.EventHandler(this.ReportViewer_Load);
//
// rptSachMuon1
//
this.rptSachMuon1.PrintOptions.PaperOrientation = CrystalDecisions.Shared.PaperOrientation.DefaultPaperOrientation;
this.rptSachMuon1.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.DefaultPaperSize;
this.rptSachMuon1.PrintOptions.PaperSource = CrystalDecisions.Shared.PaperSource.Upper;
this.rptSachMuon1.PrintOptions.PrinterDuplex = CrystalDecisions.Shared.PrinterDuplex.Default;
//
// oleDbDataAdapter1
//
this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;
this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "CHITIETPHIEUMUON", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("SOPHIEUMUON", "SOPHIEUMUON"),
new System.Data.Common.DataColumnMapping("MSSACH", "MSSACH"),
new System.Data.Common.DataColumnMapping("HANTRA", "HANTRA"),
new System.Data.Common.DataColumnMapping("Expr1", "Expr1"),
new System.Data.Common.DataColumnMapping("MSDG", "MSDG"),
new System.Data.Common.DataColumnMapping("MSNV", "MSNV"),
new System.Data.Common.DataColumnMapping("NGAYMUON", "NGAYMUON")
})
});
//
// oleDbSelectCommand1
//
this.oleDbSelectCommand1.CommandText = @"SELECT CHITIETPHIEUMUON.SOPHIEUMUON, CHITIETPHIEUMUON.MSSACH, CHITIETPHIEUMUON.HANTRA, MUONSACH.SOPHIEUMUON AS Expr1, MUONSACH.MSDG, MUONSACH.MSNV, MUONSACH.NGAYMUON FROM CHITIETPHIEUMUON INNER JOIN MUONSACH ON CHITIETPHIEUMUON.SOPHIEUMUON = MUONSACH.SOPHIEUMUON";
this.oleDbSelectCommand1.Connection = this.oleDbConnection1;
//
// oleDbConnection1
//
this.oleDbConnection1.ConnectionString = @"Integrated Security=SSPI;Packet Size=4096;Data Source=THANH;Tag with column collation when possible=False;Initial Catalog=Thuvien;Use Procedure for Prepare=1;Auto Translate=True;Persist Security Info=False;Provider=""SQLOLEDB.1"";Workstation ID=THANH;Use Encryption for Data=False";
//
// frmRptSachMuon
//
this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
this.ClientSize = new System.Drawing.Size(792, 566);
this.Controls.Add(this.ReportViewer);
this.Name = "frmRptSachMuon";
this.Text = "frmRptSachMuon";
this.Load += new System.EventHandler(this.frmRptSachMuon_Load);
this.ResumeLayout(false);
}
