CodeCharge Studio
search Register Login  

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> ASP

 how to create search using sp with parameter

Print topic Send  topic

Author Message
helpless
Posted: 05/12/2004, 6:43 AM

im using CCS demo,, i know how to do this with DW but cant figure how to use CCS.. im new with CCS but it's a great tools.
i have store procedures with 2 parameters.. i can pass parameter and get result in query analyzer
how can i creat a search page for inputing parameter
and result grid page that will return results
peterr


Posts: 5971
Posted: 05/12/2004, 12:14 PM

First you would create a standard Search form. The Search form doesn't do anything except asking users to enter values and then it converts those values into URL parameters, for example: www. website.com/Page.asp?search_field1=abc&search_field2=def

Only the grid needs to be configured to use a Stored Procedure, therefore select "Procedure" as the grid's Data Source Type.
Then open the Data Source property dialog and specify which Stored Procedure parameters should match the URL parameters created by the search form.


Also see "Using the Stored Procedure Parameter Window" section of the documentation at http://docs.codecharge.com/studio/html/UserGuide/Forms/FormDataSource.html
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com
View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.