asp dropdown to display sql stored procedures


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
    Posts
    1

    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
    Location
    Sterling Heights, Michigan
    Posts
    8,666
    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

  3. #3
    Join Date
    Oct 2008
    Posts
    142

    if this is about sql server stored procedures

    hi there,

    go to google.com and enter this

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

    you can also try this search

    Code:
    select from routine_name routine_definition information_schema
    there are other newer ways.

    to retrieve parameters, you can try these searches

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

    tonci korsano

  4. #4
    Join Date
    Feb 2012
    Posts
    1
    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
    Posts
    4
    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, 05: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
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

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