Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2010
    Posts
    4

    Question Unanswered: Stored Procedure based on user input

    Hello,

    I need help creating a stored procedure which will output a count based on user inputs from VB or C# app.

    For example:
    user will input a field name and a value from textboxes and then the stored procedure will run:

    SELECT COUNT(*) FROM table WHERE txtField = txtValue

    Finally the count result will be posted to them.

    Any ideas on how I can accomplish this?

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    CREATE PROCEDURE

    Search for the example that has a (weirdly small in my browser) heading of "B. Use a simple procedure with parameter"(about 2 thirds of the way down).
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •