reportviewer rdl文件

Question

我正在使用ReportViewer控件设计报表，但当我运行该项目时，我收到以下错误：

A data source instance has not been supplied for the data source 'DataSet1'.

下面是我的代码：

            SqlConnection myConnection = new SqlConnection();
            SqlCommand cmd = new SqlCommand();
            SqlDataAdapter sqla = new SqlDataAdapter();
            DataSet ds = new DataSet();
            DataTable dt = new DataTable();

            myConnection.ConnectionString = SqlDataSource1.ConnectionString;

            cmd.Connection = myConnection;
            cmd.CommandText ="select * from users";
            cmd.CommandType = CommandType.Text;
            sqla.SelectCommand = cmd;

            sqla.Fill(dt);
            sqla.Fill(ds);

            ReportViewer1.Reset();
            ReportViewer1.LocalReport.DataSources.Clear();
            ReportViewer1.Visible = true;
            ReportViewer1.LocalReport.ReportPath = "reports/allusers.rdl";
            ReportDataSource rds = new ReportDataSource("ds_users",dt);
            ReportViewer1.LocalReport.DataSources.Add(rds);
            ReportViewer1.ZoomMode = ZoomMode.Percent;
            ReportViewer1.LocalReport.Refresh();

我遗漏了什么？

Answer 1

我在创建rdl文件时添加了一个"DataSet1“，因此我需要将数据传递给该Dataset以呈现报表。我将ReportDataSource行更改为以下内容：

ReportDataSource rds = new ReportDataSource();
rds.Name = "DataSet1";
rds.Value = dt;

这样就解决了错误消息。