从SqlDataSource将参数传递给sproc [英] Pass parameters to sproc from SqlDataSource

问题描述

您好，

我有以下SqlDataSource代码：

Hello,
I have the following code for SqlDataSource:

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:connectionString %>"
    SelectCommand="SelectDetails"
    InsertCommand="InsertDetails"
    UpdateCommand="UpdateDetails"
    DeleteCommand="DeleteDetails"
    SelectCommandType="StoredProcedure">
    <InsertParameters>
        <asp:ControlParameter Name="Name" ControlID="nameTxt" Type="String" />
        <asp:ControlParameter Name="ID" ControlID="idTxt" Type="Decimal" />
   </InsertParameters>
    <UpdateParameters>
       <asp:ControlParameter Name="Name" ControlID="nameTxt" Type="String" />
        <asp:ControlParameter Name="ID" ControlID="idTxt" Type="Decimal" />
    </UpdateParameters>
    <DeleteParameters>
        <asp:ControlParameter Name="ID" ControlID="idTxt" Type="Decimal" />
    </DeleteParameters>
</asp:SqlDataSource>

存储过程参数是@ Name，@ ID，但是我收到错误消息我尝试调用InsertDetails，UpdateDetails和DeleteDetails时的参数。



有什么建议吗？



谢谢你提前。

Stored procedures parameters are @Name, @ID, but I get error of missing parameters when I try to call InsertDetails, UpdateDetails and DeleteDetails.

Any suggestions?

Thank you in advance.

推荐答案

ConnectionStrings：connectionString％>
SelectCommand =SelectDetails
InsertCommand =InsertDetails
UpdateCommand = UpdateDetails
DeleteCommand =DeleteDetails
SelectCommandType =StoredProcedure>
< InsertParameters>
< asp：ControlParameter Name =NameControlID =nameTxt Type =String/>
< asp：ControlParameter Name =IDControlID =idTxtType =Decimal/>
< / InsertParameters>
< UpdateParameters>
< asp：ControlParameter Name =NameControlID =nameTxtType =String/>
< asp：ControlParameter Name =IDControlID =idTxtType =Decimal/>
< / UpdateParameters>
< DeleteParameters>
< asp：ControlParameter Name =IDControlID =idTxtType =Decimal/>
< / DeleteParameters>
< / asp：SqlDataSource>

ConnectionStrings:connectionString %>" SelectCommand="SelectDetails" InsertCommand="InsertDetails" UpdateCommand="UpdateDetails" DeleteCommand="DeleteDetails" SelectCommandType="StoredProcedure"> <InsertParameters> <asp:ControlParameter Name="Name" ControlID="nameTxt" Type="String" /> <asp:ControlParameter Name="ID" ControlID="idTxt" Type="Decimal" /> </InsertParameters> <UpdateParameters> <asp:ControlParameter Name="Name" ControlID="nameTxt" Type="String" /> <asp:ControlParameter Name="ID" ControlID="idTxt" Type="Decimal" /> </UpdateParameters> <DeleteParameters> <asp:ControlParameter Name="ID" ControlID="idTxt" Type="Decimal" /> </DeleteParameters> </asp:SqlDataSource>

存储过程参数是@ Name，@ ID，但是我收到错误消息我尝试调用InsertDetails，UpdateDetails和DeleteDetails时的参数。



有什么建议吗？



谢谢你提前。

Stored procedures parameters are @Name, @ID, but I get error of missing parameters when I try to call InsertDetails, UpdateDetails and DeleteDetails.

Any suggestions?

Thank you in advance.

您需要设置 InsertCommandType ， UpdateCommandType 和 DeleteCommandType 属性为 StoredProcedure 。

You need to set the InsertCommandType, UpdateCommandType and DeleteCommandType properties to StoredProcedure.

这篇关于从SqlDataSource将参数传递给sproc的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！