private void frmRptSachTre_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 where hantra<'" + DateTime.Now + "'";
con = new SqlConnection(SqlHelper.ConnectString);
adapter = new SqlDataAdapter(sql, con);
adapter.Fill(myDataSet, "chitietphieumuon");
rptSachTre1 = new rptSachTre();
rptSachTre1.SetDataSource(myDataSet);
ReportViewer.ReportSource = rptSachTre1;
}
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;
}
