How to Pass Parameters to the Stored Procedure

Mayagadu · Post by **Mayagadu** » Thu Dec 10, 2009 12:36 pm

I need to pass parameters to the Stored Procedure. I have managed to create the Structure, but cannot pass the parameters dynamically.

How can I pass it, the video in the live demo shows how to use a stored procedure, but does not show how to pass the Parameter to the Stored Procedure.

Please help immediately.

Post by **Jan** » Fri Dec 11, 2009 1:52 am

Hello,

Please check attached sample project.

Thank you.

tynar · Post by **tynar** » Fri Jun 17, 2011 2:45 am

I would appreciate a lot if you could place mrt source file too.

Post by **Alex K.** » Fri Jun 17, 2011 5:26 am

Hello,

Please see the sample report in attachment.

Thank you.

tynar · Post by **tynar** » Wed Jun 22, 2011 5:43 am

Hello,

I have a report which shows next business day from stored procedure. So, I have added stored procedure to datasources which accepts one parameter named @StartDate and returns a date value.

In code behind I have set parameter as shown below:

report.DataSources["getNextBusinessDay"].Parameters["@StartDate"].ParameterValue = DateTime.Now;

But, I'm getting error even though I have set that parameter.

Your suggestion would be much appreciated.

Post by **Alex K.** » Thu Jun 23, 2011 5:40 am

Hello,

Can you please send us your report with sample data for analysis.

Thank you.

Alejandro323 · Post by **Alejandro323** » Fri Sep 18, 2020 8:09 pm

Greetings -!!
i have the same issue
I need to pass parameters to the Stored Procedure. I have managed to create the Structure, but the parameters not show in the browser

Post by **Lech Kulikowski** » Sat Sep 19, 2020 8:51 am

Hello,

Please check the following article:
https://www.stimulsoft.com/en/blog/arti ... ql-queries

Thank you.