ASP .NET - How to get the value from a stored procedure via a SQLDataSource

Question

Just starting to learn ASP.NET (C#) and I am using Visual Studio 2008.

I have a stored procedure:

ALTER PROCEDURE dbo.StoredProcedure1    
AS
SET NOCOUNT ON 
SELECT MAX(issue_id) FROM tableb as max_issue_id
RETURN

Which is linked to a sqlDataSource.

How do I retrieve the value from the stored procedure by using the sqlDataSource? Ideally I would like to assign this value to a variable/textbox/label.

Tim Hoolihan · Accepted Answer · 2009-06-23 18:58:47Z

1

How about something like

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
        ConnectionString="<%$ ConnectionStrings:myConnectionString %>"
        ProviderName="System.Data.SqlClient" 
        SelectCommand="StoredProcedure1" 
        SelectCommandType="StoredProcedure">
        <SelectParameters>
            <asp:ControlParameter ControlID="txtOut" Name="cpOut"               PropertyName="Text" Type="Int32" />
        </SelectParameters>
    </asp:SqlDataSource>

answered Jun 23, 2009 at 18:58

Tim Hoolihan

12.4k3 gold badges43 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

John M · Accepted Answer · 2009-06-24 16:42:50Z

0

Thanks Tim.

My final result was:

    <form id="form1" runat="server">
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
        SelectCommand="zorro" SelectCommandType="StoredProcedure"></asp:SqlDataSource>
    <br />
    <asp:DataList ID="DataList1" runat="server" DataSourceID="SqlDataSource1">
        <ItemTemplate>
            zorro:
            <asp:Label ID="zorroLabel" runat="server" Text='<%# Eval("zorro") %>' />
            <br />
            <br />
        </ItemTemplate>
     </asp:DataList>
     </form>

answered Jun 24, 2009 at 16:42

John M

14.7k29 gold badges94 silver badges143 bronze badges

Collectives™ on Stack Overflow

ASP .NET - How to get the value from a stored procedure via a SQLDataSource

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related