大家好，又见面了，我是你们的朋友全栈君。如果您正在找激活码,请点击查看最新教程,关注关注公众号 “全栈程序员社区” 获取激活教程,可能之前旧版本教程已经失效.最新Idea2022.1教程亲测有效,一键激活。
Jetbrains全系列IDE使用 1年只要46元 售后保障 童叟无欺
Hi
I have a report in windows form application that it’s designed by Stimulsoft report generator. My report get data from MySQL database by a stored procedure.
My stored procedure has a parameter as PersonalCode and my report has a parameter with same name.
I want load report file and pass a value to this parameter.
I use from some solutions that are listed in bellow, but all of them is not correct:First Way:
Stimulsoft.Report.StiReport report = new Stimulsoft.Report.StiReport();
report.Load(“mrt file path”);
report.Compile();
report.Variables[“PersonalCode”] = 932;
report.Render();
report.Show();
Second Way:
Stimulsoft.Report.StiReport report = new Stimulsoft.Report.StiReport();
report.Load(“mrt file path”);
report[“PersonalCode”] = 932;
report.Show();
Third Way:
Stimulsoft.Report.StiReport report = new Stimulsoft.Report.StiReport();
report.Load(“mrt file path”);
report.Compile();
Stimulsoft.Report.Dictionary.StiDataParameter parameter = new Stimulsoft.Report.Dictionary.StiDataParameter();
parameter.Name = “PersonalCode”;
parameter.Value = “932”;
report.DataSources[“PersonalInformation”].Parameters[“PersonalCode”] = parameter;
report.Render();
report.Show();
Fourth Way:
Stimulsoft.Report.StiReport report = new Stimulsoft.Report.StiReport();
report.Load(“mrt file path”);
report.Compile();
Stimulsoft.Report.Dictionary.StiVariable parameter = new Stimulsoft.Report.Dictionary.StiVariable(“PersonalCode”, typeof(int));
parameter.Value = “932”;
report.Dictionary.Variables[“PersonalCode”] = parameter;
report.Render();
report.Show();
Please help my,
How I can pass a value as parameter to report in .net that this parameter is a parameter for stored procedure that provide report data?
解决方案Hi
I solve my problem by bellow code:
report.Compile();
report[“Number”] = 932;
report.Render();
report.Show();
But You must attention to bellow notice:
1- Stored procedure parameter names’s must be “Number”
2- Report parameter name’s must be “Number”
3- Sent parameter name’s must be “Number”
Thanks
Open a support ticket with your question at Stimulsoft forums on :
http://forum.stimulsoft.com/[^]
There you get full support for the software developers also you provide them with code sample of your work.
Thank you
Hi
I solve my problem by bellow code:
Collapse | Copy Code
report.Compile();
report[“Number”] = 932;
report.Render();
report.Show();
But You must attention to bellow notice:
1- Stored procedure parameter names’s must be “Number”
2- Report parameter name’s must be “Number”
3- Sent parameter name’s must be “Number”
Thanks
发布者：全栈程序员-站长，转载请注明出处：https://javaforall.net/158798.html原文链接：https://javaforall.net
