为SQL报告服务设置参数时出现C#错误 [英] C# Error when setting parameter for SQL reporting service
本文介绍了为SQL报告服务设置参数时出现C#错误的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
嗨伙计
我在添加时遇到以下错误
Hi Folks
I am getting following error when adding
reportViewer1.LocalReport.SetParameters(paramz);
AccessViolationException was unhandled<br />
Attempted to read or write protected memory. This is often an indication that other memory is corrupt.<br />
ReportParameter[] paramz = new ReportParameter[3];
reportViewer1.LocalReport.ReportEmbeddedResource = "Reports.ReportInvoice.rdlc";
paramz[0] = new ReportParameter("paramValueInWord", inWord);
paramz[1] = new ReportParameter("paramPreviousBalance", previousBalance.ToString());
paramz[2] = new ReportParameter("paramTodaysReceipt", todaysReceipt.ToString());
reportViewer1.LocalReport.Refresh();
reportViewer1.LocalReport.SetParameters(paramz);
reportViewer1.LocalReport.DataSources.Clear();
ReportDataSource rds = new ReportDataSource();
rds.Name = "report_DataSet";
rds.Value = reportDT;
reportViewer1.LocalReport.DataSources.Add(rds);
reportViewer1.RefreshReport();
请帮助
提前谢谢...
Please help
Thanks in advance...
推荐答案
试试这个:
而不是ServerReport
Let try this:
Instead of ServerReport
ReportViewer1.ProcessingMode = ProcessingMode.Remote;
ServerReport serverReport;
serverReport = ReportViewer1.ServerReport;
serverReport.ReportServerUrl = new Uri(ReportServerTextBox.Text);
serverReport.ReportPath = FolderTextBox.Text + ReportNameTextBox.Text;
ReportParameter[] rp = new ReportParameter[1];
rp[0] = new ReportParameter("OrderID", txtOrderID.Text);
ReportViewer1.ServerReport.SetParameters(rp);
ReportViewer1.ServerReport.Refresh();
我已经过测试和工作。
I have tested and worked.
这篇关于为SQL报告服务设置参数时出现C#错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文