如何在c#中绑定一个数据集到CrystalReport
本文关键字:一个 数据集 CrystalReport 绑定 | 更新日期: 2023-09-27 17:53:39
我有一个数据库,我想在我的报告(水晶报告)中使用一些它的表,在我的代码中,我有
testdbDataSet ds = new testdbDataSet();
testdbDataSetTableAdapters.ProductsTableAdapter productAdapter = new testdbDataSetTableAdapters.ProductsTableAdapter();
productAdapter.Fill(ds.Products);
testdbDataSetTableAdapters.RegionTableAdapter regionAdapter = new testdbDataSetTableAdapters.RegionTableAdapter();
regionAdapter.Fill(ds.Region);
ds.AcceptChanges();
ReportDocument reportDoc = new ReportDocument();
reportDoc.FileName = "CrystalReport1.rpt";
reportDoc.SetDataSource(ds);
crystalReportViewer1.ReportSource = reportDoc;
crystalReportViewer1.Show();
- ds是。xds数据集的实例
crystalReportViewer不显示我的报告
我在stackoverflow上检查了这个链接,但是无法完成
testdbDataSet ds = new testdbDataSet();
//FETCH FROM ANYWHERE TO a DataTable
DataTable _DtFrmDBPrd = new DataTable();
DataTable _DtFrmDBRgn = new DataTable();
_DtFrmDBPrd = GetDataFrmDBPrd();//Filling the DataTable From DB or any where..
_DtFrmDBRgn = GetDataFrmDBRgn();
ds.Products.Merge(_DtFrmDBPrd);//Both the Data Table should have the same column name and Data Type
ds.Region.Merge(_DtFrmDBRgn);
ReportDocument reportDoc = new ReportDocument();
reportDoc.FileName = "CrystalReport1.rpt";
reportDoc.SetDataSource(ds);
crystalReportViewer1.ReportSource = reportDoc;
crystalReportViewer1.Show();