Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > sqldatasource using a stored procedure with OUTPUT parameters only

Reply
Thread Tools

sqldatasource using a stored procedure with OUTPUT parameters only

 
 
Andy in South Jersey
Guest
Posts: n/a
 
      02-11-2009
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:

<asparameter 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.
 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
sqlDataSource UpdateQuery withe stored procedure and parameters? Scott.Metzger ASP .Net 4 10-06-2009 07:28 AM
sqldatasource using a stored procedure with OUTPUT parameters only Andy in South Jersey ASP .Net 3 02-11-2009 02:51 PM
sqldatasource using a stored procedure with OUTPUT parameters only Andy in South Jersey ASP .Net 0 02-11-2009 01:53 PM
sqldatasource using a stored procedure with OUTPUT parameters only Andy in South Jersey ASP .Net 0 02-11-2009 01:51 PM
get an output value from a stored procedure using sqlDataSource michelle ASP .Net 3 02-14-2006 02:31 PM



Advertisments