Binding return value of SqlDataSource to some tag

Question

User1352601651 posted

Hello,

I have a structure like this:

<asp:Repeater ID="someId" DataSourceID="someDataId" runat="server">
   ...
        <ItemTemplate>

                <%# DataBinder.Eval(Container.DataItem, " ???? ").ToString() //how can I get return value here? %>

       </ItemTemplate>       

</asp:Repeater>

<asp:SqlDataSource ID="someDataId" runat="server" ConnectionString="<%$ MyConnString %>"
        CancelSelectOnNullParameter="False" SelectCommand="mySPName" SelectCommandType="StoredProcedure">       
        <SelectParameters>         
            <asp:Parameter Direction="ReturnValue" DbType="Int32" Name="return_value" DefaultValue="0" />  <%--is it right?--%>
            <asp:SessionParameter DefaultValue="1" Name="inputValue" SessionField="inputValue" Type="Int32" />
        </SelectParameters>
    </asp:SqlDataSource>

I can get any data from sql data source by using DataBinder except returned value. How can I also get return value?

Thank you.

Answer 1

User1224194097 posted

Just use SELECT yourVariableName as SomeColumnName in the stored procedure.

You can extract ColumnName in the repeater as

<%# Eval("SomeColumName").ToString() %>

Answer 2

User1352601651 posted

I know how to get a column from stored procedure. I need to get return value. Because I need to get row count value, and in some reasons I can't add row count value into the result table in my stored procedure.