asp dropdown to display sql stored procedures
I am new to asp. How would I go about creating a dropdown list to display the sql stored procedures for a particular database? I am trying to develop an form for users to select at sql stored procedure form that list and then depending upon which stored procedure they pick, they will then enter in a text box the paramenters that the stored proc requires, then hit a submit button to execute that stored proc. I am unsure how to go about this. Any help would be great.
I don't know it if is real good idea to store the actual stored procedure names for all to see.
I think maybe creating a psudeo name for them and evaluting what was selected in a SELECT CASE may be an option.
I don't answer coding questions via PM or Email. Please post a thread in the appropriate forum section.
Please use [Code]your code goes in here[/Code] tags when posting code.
Before posting your question, did you look here
Got a question on Linux? Visit our Linux sister site.
Modifications Required For VB6 Apps To Work On Vista
if this is about sql server stored procedures
go to google.com and enter this
in the search text box.
select from sysobjects where type 'p'
you can also try this search
there are other newer ways.
select from routine_name routine_definition information_schema
to retrieve parameters, you can try these searches
1. retrieve stored procedure parameters sql server
2. retrieve stored procedure parameters with tsql
it won't be a good idea to put SP names in the textbox. Instead, think from the user's point of view and put something users can understands. Know your users.
I think it's better to output a list of some actions which you want to allow the user to do (free human-readable text, you can create the complete list just in your ASP code), and to have a list of your stored procedures, which correspond to your actions. No need to read the SPs names from DB, you can make the list in your code in the same way as actions. When the user selects some action, you just find which SP correspond to that action and execute the SP with user's parameters.
By Col in forum VB Classic
Last Post: 10-25-2001, 09:34 PM
By Jamie Cross in forum authorevents.mitchell
Last Post: 10-17-2000, 06:07 PM
By Lamarr in forum VB Classic
Last Post: 07-28-2000, 11:42 AM
By Jai Singh in forum VB Classic
Last Post: 07-12-2000, 01:24 PM
By Ray in forum VB Classic
Last Post: 03-27-2000, 06:37 PM
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL