string strProvider = "Server=(local);DataBase=pubs;UID=sa;PWD=19";
SqlConnection MyConn = new SqlConnection(strProvider);
MyConn.Open();
string strSel = "Select * from employee where fname like 'P%'";
SqlDataAdapter MyAdapter = new SqlDataAdapter(strSel,MyConn);
DataSet1 ds = new DataSet1();//这个DataSet1在结构上最好跟水晶表的一致,
//路径可以不同
MyAdapter.Fill(ds,"employee) MyConn.Close();
reportDocument1.Load("d://Report2.rpt");
reportDocument1.SetDataSource(ds);
this.CrystalReportViewer1.ReportSource = reportDocument1;
CrystalReportViewer1.DataBind();
dataset作为水晶报表数据源
最新推荐文章于 2021-07-07 16:44:29 发布