Page 1 of 1

How to Pass Parameters to the Stored Procedure

Posted: Thu Dec 10, 2009 12:36 pm
by Mayagadu
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.

How to Pass Parameters to the Stored Procedure

Posted: Fri Dec 11, 2009 1:52 am
by Jan
Hello,

Please check attached sample project.

Thank you.

How to Pass Parameters to the Stored Procedure

Posted: Fri Jun 17, 2011 2:45 am
by tynar
I would appreciate a lot if you could place mrt source file too.

How to Pass Parameters to the Stored Procedure

Posted: Fri Jun 17, 2011 5:26 am
by Alex K.
Hello,

Please see the sample report in attachment.

Thank you.

How to Pass Parameters to the Stored Procedure

Posted: Wed Jun 22, 2011 5:43 am
by tynar
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.

How to Pass Parameters to the Stored Procedure

Posted: Thu Jun 23, 2011 5:40 am
by Alex K.
Hello,

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

Thank you.

Re: How to Pass Parameters to the Stored Procedure

Posted: Fri Sep 18, 2020 8:09 pm
by Alejandro323
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

Re: How to Pass Parameters to the Stored Procedure

Posted: Sat Sep 19, 2020 8:51 am
by Lech Kulikowski
Hello,

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

Thank you.