iSeller Commerce
iSeller POS Retail
iSeller POS F&B
iSeller POS Express
Crosslight
WebUI
ClientUI
What's New
Download Trial
Web Solution
Mobile Solution
Enterprise Solution
Custom Development
Blog
Community
Latest Development Blogs
ForumPostTopic
Browse By Tag
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.
Thank you! I'm having some difficulty locating this page in the samples. Would you have the complete URL?
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.aspxRegards,Hans K.
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
Hello,Is the solution that you found have resolved your issue?Regards,Hans K.
Hello - Yes that solution did resolve the issue. Thanks!
or
Choose this if you're already a member of Intersoft Community Forum. You can link your OpenID account to your existing Intersoft Social ID.
Choose this if you don't have an Intersoft account yet. Your authenticated OpenID will be automatically linked to your new Intersoft account.
Enter your Wordpress Blogname
Creating your account...