62,074
社区成员
发帖
与我相关
我的任务
分享
protected void Button2_Click(object sender, EventArgs e)
{
ReportDocument ReportDoc = new ReportDocument();
ReportDoc.Load(@"F:\rpt\CrystalReport1.rpt");
string strProvider = "Server=127.0.0.1;Uid=sa;Pwd=sa123;connection lifetime=180;Connection Timeout=300;Database=TestDB";
SqlConnection MyConn = new SqlConnection(strProvider);
MyConn.Open(); string strSel = "Select * from TestTable";
SqlDataAdapter MyAdapter = new SqlDataAdapter(strSel, MyConn);
//-----------------------------------------------------
DataSet ds = new DataSet();
MyAdapter.Fill(ds, "TestTable");
ReportDoc.SetDataSource(ds);
CrystalReportViewer1.ReportSource = ReportDoc;
CrystalReportViewer1.DataBind();
}