打印水晶报表1

//1。 appConfig配置信息:

 <startup useLegacyV2RuntimeActivationPolicy="true">
    <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0" />
  </startup>  

operate.OpenConnection();//打开数据库连接
                //>>>(1)报表字段对应数据集字段
                //Crystal_userPizeByDataSource userPrize = new Crystal_userPizeByDataSource();
                //>>>(2)报表字段对应数据库字段
                // Crystal_userPrize userPrize = new Crystal_userPrize();

//=========== 打印报表方式1:使用数据集 ==================
                //  DataSet1 ds = new DataSet1();//生成数据集对象
                //生成数据集表适配器对象
                //DataSet1TableAdapters.tb_prizeTableAdapter adapter = new DataSet1TableAdapters.tb_prizeTableAdapter();
                //adapter.Fill(ds.tb_prize);//填冲数据
                //Crystal_userPrize userPrize = new Crystal_userPrize();//生成报表对象
                //  Crystal_userPizeByDataSource userPrize = new Crystal_userPizeByDataSource();
                // userPrize.SetDataSource(ds);//设置数据源
                //   this.crystalReportViewer1.ReportSource = userPrize;//显示报表

  //=========打印报表方式2:使用DataSet========                        
                DataSet ds = operate.GetDataSet("select * from tb_prize");
                //生成报表对象             
                Crystal_userPizeByDataSource userPrize = new Crystal_userPizeByDataSource();
                //或使用:Crystal_userPrize userPrize = new Crystal_userPrize();
                userPrize.SetDataSource(ds.Tables[0].DefaultView);//设置数据源            
                this.crystalReportViewer1.ReportSource = userPrize;//显示报表

 //=====最后关闭数据库连接=========

operate.CloseConnection();//关闭数据库连接


                

原文地址:https://www.cnblogs.com/xiaowei-blog/p/4166826.html