如何将数据表绑定到报表查看器运行时

素材狗 2021-01-01 08:11:38 文章分类：数据库问题点击数：2次

文章标签

How to bind datatable to reportviewer runtime(如何将数据表绑定到报表查看器运行时)

本文介绍了如何将数据表绑定到报表查看器运行时的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

我想使用以下代码将 datatable 绑定到 reportviewer.我在 reportviewer 中看不到结果，下面缺少脚本怎么办?

I want to do a bind datatable to reportviewer with the code below. I don't see the results appear in the reportviewer, what the lack of script below?

// create dataset
DataSet ds = new DataSet("myDataset");

// create datatable
DataTable dt = new DataTable("myDatatable");

// add columns
dt.Columns.Add("column1", typeof(string));
dt.Columns.Add("column2", typeof(string));
dt.Columns.Add("column3", typeof(string));

// insert data rows
dt.Rows.Add("row1-col1", "row1-col2", "row1-col3");
dt.Rows.Add("row2-col1", "row2-col2", "row2-col3");

// add datatable to dataset 
ds.Tables.Add(dt);

// bind datatable to report viewer
this.reportViewer.Reset();
this.reportViewer.ProcessingMode = ProcessingMode.Local;
this.reportViewer.LocalReport.ReportEmbeddedResource = "Test.Report1.rdlc";
this.reportViewer.LocalReport.DataSources.Clear();
this.reportViewer.LocalReport.DataSources.Add(new ReportDataSource(dt.TableName, dt));
this.reportViewer.RefreshReport();

推荐答案

我找到了如何将数据表绑定到报表查看器的答案，我将在这里分享可能对其他人有用.

I found the answer how to bind datatable to reportviewer, I will shared here may be useful for others.

添加到表单clsTables 类、Report1.rdlc 文件、reportViewer1.
然后点击reportViewer1的右上角，将选择报告设置为Test.Report1.rdlc.
关于 Report1.rdlc
- 点击新建，
- 添加数据集名称:dsBody数据源:测试可用数据集:clsTables
- 点击确定
- 右键单击 Report1.rdlc 选择 插入表，将 dsBody 元素(Column0、Colum1、Column2)拖到 Report1.rdlc 表.

Add to form clsTables class, Report1.rdlc file, reportViewer1.
Then Click on the upper right corner of the reportViewer1, set choose report to Test.Report1.rdlc.
On Report1.rdlc
- Click New,
- Add dataset name: dsBody Data source: Test Available dataset: clsTables
- Click Ok
- Right click on Report1.rdlc select Insert Table, drag dsBody element(Column0, Colum1, Column2) to Report1.rdlc table.

Namespace Test{
    public class clsTables {
        // constructor
        public clsTables(string col0, string col1, string col2) {
            this.Column0= col0;
            this.Column1= col1;
            this.Column2= col2;
        }

       // properties
       public string Column0{ get; set; }
       public string Column1{ get; set; }
       public string Column2{ get; set; }
    }
}

namespace Test{
    public class clsMain{
        public void BindToRepprtViewer() {        
            // create dataset
            DataSet ds = new DataSet("myDataset");

            // create datatable
            DataTable dt = new DataTable("myDatatable");

            // add columns
            dt.Columns.Add("column1", typeof(string));
            dt.Columns.Add("column2", typeof(string));
            dt.Columns.Add("column3", typeof(string));

            // insert data rows
            dt.Rows.Add("row1-col1", "row1-col2", "row1-col3");
            dt.Rows.Add("row2-col1", "row2-col2", "row2-col3");

            // add datatable to dataset 
            ds.Tables.Add(dt);

            // save rows to rowList 
            List<clsTables> rowList = new List<clsTables>();
            rowList .Clear();
            foreach (DataRow row in dt.Rows) {
                rList.Add(new clsTables(Convert.ToInt32(row.ItemArray[0]), row.ItemArray[1].ToString(), row.ItemArray[2].ToString()));
            }

            // binding rowList to bs
            BindingSource bs = new BindingSource();
            bs.DataSource = rowList;

            // binding bs to rds
            ReportDataSource rds = new ReportDataSource();
            rds.Name = "dsBody";
            rds.Value = bs;

            // binding rds to report viewer
            reportViewer1.Reset();
            reportViewer1.LocalReport.ReportEmbeddedResource =  "Test.Report1.rdlc";
            reportViewer1.LocalReport.DataSources.Clear();
            reportViewer1.LocalReport.DataSources.Add(rds);
            reportViewer1.RefreshReport();
        }
    }
}