DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 5 of 5

Thread: asp dropdown to display sql stored procedures

  1. #1
    Join Date
    Jan 2012

    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.

  2. #2
    Join Date
    Apr 2007
    Sterling Heights, Michigan
    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.

  3. #3
    Join Date
    Oct 2008

    if this is about sql server stored procedures

    hi there,

    go to and enter this

    select from sysobjects where type 'p'
    in the search text box.

    you can also try this search

    select from routine_name routine_definition information_schema
    there are other newer ways.

    to retrieve parameters, you can try these searches

    1. retrieve stored procedure parameters sql server
    2. retrieve stored procedure parameters with tsql
    good luck,

    tonci korsano

  4. #4
    Join Date
    Feb 2012
    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.

  5. #5
    Join Date
    Jul 2011
    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.

Similar Threads

  1. Stored procedures and multiple databases
    By Col in forum VB Classic
    Replies: 0
    Last Post: 10-25-2001, 08:34 PM
  2. Dynamic SQL or Stored Procedures..your opinion
    By Jamie Cross in forum authorevents.mitchell
    Replies: 1
    Last Post: 10-17-2000, 05:07 PM
  3. Replies: 0
    Last Post: 07-28-2000, 10:42 AM
  4. Replies: 0
    Last Post: 07-12-2000, 12:24 PM
  5. VB 6 and SQL Server 7.0 Stored procedures
    By Ray in forum VB Classic
    Replies: 3
    Last Post: 03-27-2000, 06:37 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center