水晶报表引用DataSet做数据源

it2022-05-09  28

using   CrystalDecisions.Shared   ;     using   CrystalDecisions.CrystalReports   .Engine   ;     。。。。。。     public   class   WebForm2   :   System.Web.UI.Page     {     protected   CrystalDecisions.Web.CrystalReportViewer   CrystalReportViewer1;     protected   CrystalDecisions.CrystalReports.Engine.ReportDocument   reportDocument1;         private   void   Page_Load(object   sender,   System.EventArgs   e)     {     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();

转载于:https://www.cnblogs.com/tuyile006/archive/2006/07/27/460537.html


最新回复(0)