在ASP.Net 2010中重新整理Reportviewer参数的问题

本文介绍了在ASP.Net 2010中重新整理Reportviewer参数的问题的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

我正在尝试使用某些参数在运行时生成报告.但是出现此错误
尚未为数据源数据集1提供数据源实例"
我已经完成了以下操作.
1.使用诸如SELECT * FROM Sreenath之类的查询创建数据集，其中Sree = @ Sree.此Sreenath表具有Sree和ID作为列.
2.标记为Report1.rdlc.
3.将Report1.rdlc附加到reportviewer.
4.在运行时，我尝试通过以下方式刷新报告...
第一种方式:

Hi,
I am trying to generate report during runtime using some parameters.But I am getting this error
"a data source instance has not been supplied for the data source dataset1"
I have done the following.
1.Created Dataset with query like SELECT * FROM Sreenath where Sree=@Sree. This Sreenath table has got Sree and ID as columns.
2.Tagged it to Report1.rdlc.
3.Attached Report1.rdlc to a reportviewer.
4.While runtime I trying to refresh the report in following ways...
First way:

ReportParameter lObjParam = new ReportParameter("Sree", aStrSree);
ReportParameter[] lArrParam = { lObjParam };
ReportViewer3.LocalReport.SetParameters(lArrParam);
ReportViewer3.LocalReport.Refresh();

第二路

Second Way

string lStrReportPath = ReportViewer3.LocalReport.ReportPath;
DataSet2.SreenathDataTable lDS = new DataSet2.SreenathDataTable();
DataSet2TableAdapters.SreenathTableAdapter lAdapter = new DataSet2TableAdapters.SreenathTableAdapter();
lDS = lAdapter.GetDataIds(aStrSree);
int lIntResult = lAdapter.Fill(lDS, aStrSree);
ReportDataSource lDTSource = new ReportDataSource("DataSet2_Sreenath", (DataTable)lDS);
ReportViewer3.LocalReport.DataSources.Clear();
ReportViewer3.LocalReport.ReportPath = lStrReportPath;
ReportViewer3.LocalReport.DataSources.Add(lDTSource);
ReportViewer3.LocalReport.Refresh();

我在这里做错什么了...

What is that I am doing wrong here…
Any help over here please.

推荐答案

sqlconnection con=new sqlconnection(//your connection string);
sqlcommand cmd=new sqlcommand("SELECT * FROM Sreenath where Sree=@Sree",con);
cmd.Parameters.AddWithValue("@Sree",//your value);
sqldataadapter adapter=new sqldataadapter();
adapter.selectcommand=cmd;
Dataset ds=new dataset();
adapter.fill(ds);
Microsoft.Reporting.WinForms.ReportDataSource reportDataSource1 = new Microsoft.Reporting.WinForms.ReportDataSource("*.rdlc file datasource", ds.Tables[0]);/*for check datasource name open *.rdlc file and go to report menu->Datasources...*/

reportViewer1.LocalReport.DataSources.Clear();/*Clear datasource*/
            reportViewer1.LocalReport.DataSources.Add(reportDataSource1);/*Add Data Source*/
            reportViewer1.RefreshReport();

这篇关于在ASP.Net 2010中重新整理Reportviewer参数的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！

from