rdlc页面未获取存储过程结果 [英] rdlc page not getting stored procedure result

问题描述

你好朋友

以下是我使用rdlc report获取报告的代码.

我有一个带reportviewer的Web表单，单击按钮后，我向存储过程发送了一个案例号，但是我无法获得存储过程的结果

在报告页面的button_click事件中

Hi friends

The following is my code for get report using rdlc report.

I have a web form with reportviewer and the in a button click i sent a casenumber to storeprocedure but i can''t get the result of the stored procedure

in button_click event of the report page

string casenumber = textBox1.Text;
            ReportParameter[] rp = new ReportParameter[1];
            rp[0] = new ReportParameter("CaseNumber", casenumber);

            reportViewer1.LocalReport.SetParameters(rp);

并通过选择reportviewer控件的数据源来绑定数据源.

结果仅显示报告页面的设计.报告中没有可用数据.

and bind the datasource by selecting the datasource of the reportviewer control.

and the result is only show the design of report page. no data available in report.

推荐答案

以下是使用存储过程和数据集绑定报表查看器的代码

Here is the code to bind the Report Viewer using the Stored Procedure and Data Set

// Get the data table using stored procedure.
SqlCommand cmd = new SqlCommand("GetEmployeeDetailsList", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);

// Initialize the Report Data Source.
// DataSet1 -- Name of the Data Set created
ReportDataSource rds = new ReportDataSource("DataSet1", dt);


// bind datatable to report viewer
ReportViewer1.Reset();
ReportViewer1.ProcessingMode = ProcessingMode.Local;
// Path to your rdlc file.
ReportViewer1.LocalReport.ReportPath = Server.MapPath("/EmpReport.rdlc");
// Name of your rdlc file.
ReportViewer1.LocalReport.ReportEmbeddedResource = "EmpReport.rdlc";
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(rds);

您可以参考下面的链接以获取更多详细信息.

将数据表绑定到rdlc和reportviewer

you can refer to below link for more details.

bind datatable to rdlc and reportviewer

这篇关于rdlc页面未获取存储过程结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！