sqldatasource using a stored procedure with OUTPUT parameters only

Discussion in 'ASP .Net' started by Andy in South Jersey, Feb 11, 2009.

  1. I have a sqldatasource control that has SelectCommand set to StoredProcedure,
    and that stored procedure only returns OUTPUT parameters, it doesn't return a
    recordset. It has one INPUT parameter. I would like to set the OUTPUT
    values that are returned by the SP to the text value of labels that I have on
    my page.

    When I configure the datasource I set the Direction to Output, I then
    "Finish" and when I go back to the configuration it says InputOutput, but the
    source code says:

    <asp:parameter Direction="Output" Name="weight" Type="Int32" />

    So, that was an initial concern, but I don't think that's the problem.

    Via SQL Profiler I don't see the stored procedure being called. Do I have
    to associate it with a control to be called?

    Do I set the values for the labels in the _selected event? At this point, I
    can't get the _selected event for the sqldatasource to occur.
     
    Andy in South Jersey, Feb 11, 2009
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. michelle
    Replies:
    3
    Views:
    7,262
    Tapio Kulmala
    Feb 14, 2006
  2. =?Utf-8?B?RGFuIFNpa29yc2t5?=

    Using Stored Procedure in SqlDataSource Won't Workd

    =?Utf-8?B?RGFuIFNpa29yc2t5?=, Jul 28, 2006, in forum: ASP .Net
    Replies:
    10
    Views:
    3,676
    aadames
    Oct 31, 2007
  3. Andy in South Jersey
    Replies:
    3
    Views:
    2,765
    Andy in South Jersey
    Feb 11, 2009
  4. Andy in South Jersey
    Replies:
    0
    Views:
    387
    Andy in South Jersey
    Feb 11, 2009
  5. Andy in South Jersey
    Replies:
    0
    Views:
    430
    Andy in South Jersey
    Feb 11, 2009
  6. Scott.Metzger
    Replies:
    4
    Views:
    1,257
    Alexey Smirnov
    Oct 6, 2009
  7. Bari Allen

    Stored Procedure Output Parameters

    Bari Allen, Sep 17, 2004, in forum: ASP General
    Replies:
    1
    Views:
    239
    Bob Barrows [MVP]
    Sep 17, 2004
  8. stjulian
    Replies:
    1
    Views:
    299
    Bob Barrows [MVP]
    Feb 8, 2006
Loading...