一个reportviewer 动态加载不同的report

最新推荐文章于 2022-08-09 15:28:31 发布

原创最新推荐文章于 2022-08-09 15:28:31 发布 · 1.9k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#dataset #command #security #string #report #user

C# 专栏收录该内容

9 篇文章

订阅专栏

本文介绍了一种根据用户选择的不同选项（年或月），动态切换数据库连接、执行SQL查询并填充数据集的方法。之后，根据不同的数据集更新报表资源，并通过ReportViewer组件展示出来。该过程包括了数据库连接管理、数据集填充、报表资源指定及报表刷新等关键步骤。

            if (listBox1.SelectedItem.ToString()== "年")
            {
                string connstring = "Data Source=.;Initial Catalog=Northwind;Integrated Security=True";

System.Data.SqlClient.SqlConnection conn1 = new System.Data.SqlClient.SqlConnection(connstring);

System.Data.SqlClient.SqlCommand command1 = new System.Data.SqlClient.SqlCommand("select * from Customers", conn1);

System.Data.SqlClient.SqlDataAdapter ada1 = new System.Data.SqlClient.SqlDataAdapter(command1);

DataSet c_ds = new DataSet();

try
{

conn1.Open();

ada1.Fill(c_ds);

}

finally
{

conn1.Close();

command1.Dispose();

conn1.Dispose();

                }
                this.reportViewer1.Reset();
                this.reportViewer1.LocalReport.ReportEmbeddedResource = "report.Report1.rdlc";

//指定数据集,数据集名称后为表,不是DataSet类型的数据集

this.reportViewer1.LocalReport.DataSources.Clear();

this.reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("CustomDS_Customers", c_ds.Tables[0]));
// this.reportViewer3.LocalReport.DataSources.Add(c_ds);

//显示报表

                this.reportViewer1.RefreshReport();

            }
            else if (listBox1.SelectedItem.ToString() == "月")
            {
                string connstring = "Data Source=.;Initial Catalog=Energy;Integrated Security=True";

System.Data.SqlClient.SqlConnection conn1 = new System.Data.SqlClient.SqlConnection(connstring);

System.Data.SqlClient.SqlCommand command1 = new System.Data.SqlClient.SqlCommand("select * from User_energy", conn1);

System.Data.SqlClient.SqlDataAdapter ada1 = new System.Data.SqlClient.SqlDataAdapter(command1);

DataSet c_ds = new DataSet();

try
{

conn1.Open();

ada1.Fill(c_ds);

}

finally
{

conn1.Close();

command1.Dispose();

conn1.Dispose();

                }
                this.reportViewer1.Reset();
                this.reportViewer1.LocalReport.ReportEmbeddedResource = "report.Report2.rdlc";
                this.reportViewer1.LocalReport.DataSources.Clear();
                this.reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("User_energy", c_ds.Tables[0]));
                this.reportViewer1.RefreshReport();
            }