Get sproc return value from ObjectDataSource

Bob Bedell · January 17th, 2008, 06:15 PM

Hi folks,

I have a SqlDataSource object with the folloiwng parameters:

Code:

<SelectParameters>
         <asp:ControlParameter Name="pageNum" ControlID="pn1" PropertyName="SelectedPage" />
         <asp:Parameter DefaultValue="10" Name="pageSize" Type="Int32" />
         <asp:Parameter Name="pageCount" Direction="ReturnValue" Type="Int32" />
</SelectParameters>

I can access the return value parameter in code with:

Code:

protected void SqlDataSource1_Selected(object sender, System.Web.UI.WebControls.SqlDataSourceStatusEventArgs e)
    {
        int pages;
        pages = (int)e.Command.Parameters["@pageCount"].Value;
        pn1.Count = pages;
        Pn2.Count = pages;
    }

I'm re-writing the app using business objects and ObjectDataSource controls. The ObjectDataSourceStatusEventArgs doesn't have a Command.Parameters collection. How do you access an ObjectDataSource return parameter when you business methods execute stored procedures that return values?

ObjectDataSourceStatusEventArgs has a ReturnValue property, but it references the return value of the business method (in my case a collection), not the return value of the stored procedure executed by the business method.

Any thoughts much appreciated.

Bob

Imar · January 17th, 2008, 07:01 PM

Hi Bob,

You could create a property on the collection and update in from within the code that talks to the stored procedure.
The ObjectDataSource shouldn't know about implementation. E.g. it shouldn't have to understand whether underlying code calls a stored procedure, an XML file or just makes something up itself. Therefore you need to solve this through the business objects themselves.

HtH,

Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

Bob Bedell · January 17th, 2008, 07:57 PM

Thanks Imar. That makes sense.

Bob

Bob Bedell · January 19th, 2008, 10:22 PM

This problem resolved at:

http://p2p.wrox.com/topic.asp?TOPIC_ID=68430

Apologies for posting versions of it all over town. :)

Bob