SQLdatasource使用存储过程的问题.

Question

<asp:sqldatasource selectcommand="存储过程名"/>
如何将参数传入这个存储过程

Answer 1

<asp:SqlDataSource ID="SDS_border" runat="server"  ConnectionString="<%$ ConnectionStrings:dbconn %>" SelectCommand="border_sel_topn" SelectCommandType="StoredProcedure" DeleteCommand="border_delete" DeleteCommandType="StoredProcedure" InsertCommand="border_add" InsertCommandType="StoredProcedure" UpdateCommand="border_update">
        <SelectParameters>
            <asp:Parameter DefaultValue="0" Name="topn" Type="Int32" />
        </SelectParameters>
        <DeleteParameters>
            <asp:Parameter Name="border_id" Type="Int32" />
            <asp:Parameter Direction="Output" Name="msg" Type="String" Size="500" />
        </DeleteParameters>
        <UpdateParameters>
            <asp:Parameter Name="border_name" Type="String" />
            <asp:Parameter Name="type_id" Type="Int32" />
            <asp:Parameter Name="border_id" Type="Int32" />
        </UpdateParameters>
        <InsertParameters>
            <asp:Parameter Name="border_name" Type="String" />
            <asp:Parameter Name="type_id" Type="Int32" />
            <asp:Parameter Direction="Output" Name="msg" Type="String" Size="500" />
        </InsertParameters>
    </asp:SqlDataSource>