Intersoft Community - ISDataSource - ISDataSource - Stored Procedure with Input Parameters

ISDataSource - Stored Procedure with Input Parameters

Hans — Thu, 28 Aug 2014 21:44:01 GMT

Hello,

You’re welcome.
Should you have further question, please do not hesitate to contact us.

Regards,
Hans K.

ISDataSource - Stored Procedure with Input Parameters

cvgierloff — Thu, 28 Aug 2014 09:21:00 GMT

Hello - Yes that solution did resolve the issue. Thanks!

ISDataSource - Stored Procedure with Input Parameters

Hans — Tue, 19 Aug 2014 22:32:16 GMT

Hello,

Is the solution that you found have resolved your issue?

Regards,
Hans K.

ISDataSource - Stored Procedure with Input Parameters

cvgierloff — Tue, 19 Aug 2014 09:39:26 GMT

Hello - I reviewed the sample and made the following changes: 1) Changed the stored procedure to accept varchar(10) datatype (i.e. handles date string in mm/dd/yyyy format), 2) Updated the dataset, 3) The ISDataSource parameters are now set to 'String' datatype. The problem is that the value of the text boxes is still not being passed to the stored procedure. I have a trap in the stored procedure to handle null values and that is being executed. Is there no way to pass parameters to a stored procedure via ISDataSource?

Found solution... It didn't click that select parameters for ISDataSource can be set like a "regular" asp.net SqlDataSource. Thus, I'm setting the defaults as in the following example.

ISDataSource1.Tables(0).SelectParameters("MinEffDate").DefaultValue = Today.ToShortDateString

ISDataSource - Stored Procedure with Input Parameters

Hans — Mon, 18 Aug 2014 22:27:34 GMT

Hello,

You could go to the ISDataSource Samples Solution from:
Start > All Programs > Intersoft WebUI Studio 2014 R1 > WebUI Studio for ASP.NET > ISDataSource > C# Samples.

Or you acces the physical location of the file is: "%ProgramFiles%\Intersoft Solutions\Intersoft Premier Studio 2014 R1\Samples\For ASP.NET\ISNet.WebUI.Samples\cs\ISDataSource\UsingSortParameterName.aspx

Regards,
Hans K.

ISDataSource - Stored Procedure with Input Parameters

cvgierloff — Mon, 18 Aug 2014 10:38:00 GMT

Thank you! I'm having some difficulty locating this page in the samples. Would you have the complete URL?

ISDataSource - Stored Procedure with Input Parameters

Hans — Mon, 18 Aug 2014 05:05:50 GMT

Hello,

You could see the example about input parameter in ISDataSourse from ISDataSource Samples Solution.
For example, you could review “UsingSortParameterName.aspx” page, to see the result.

After have review on your code, the issue occurs, due to you pass an incorrect input type to the ISDataSource.

You get the input value from ASP.Net TextBox (MinEffDate) which is has a String type.
However, in ISDataSource, the parameter (MinEffDate) has a DateTime type.

Please kindly ensure the input and parameter in ISDataSource has a same type, like in “UsingSortParameterName.aspx” page.

Thank you.

Regards,
Hans K.

ISDataSource - Stored Procedure with Input Parameters

cvgierloff — Fri, 15 Aug 2014 11:36:53 GMT

I created an ISDataSource (version 1.0.1500) on a web form in order to populate a webgrid (version 8). The The schema type for the ISDataSource is a dataset that calls a stored procedure with 2 input paramaters. The Select method is set to pull the parameter values from text boxes on the web form. This is being done to allow the end user to control the amount of data returned to the grid. Due to the large volume of data available we want to display a smaller amount in the grid initially and allow the end user to add more by changing the values in the text boxes and refreshing.

The program is ignoring the values entered into the textboxes. Would it be possible to obtain a sample of how to use an ISDataSource with a stored procedure and input parameters that are on a web form? I reviewed the documentation extensively but there isn't much detail on parameters and ISDataSource.