定义SqlDataSource命令的参数 [英] Define parameter for commands of SqlDataSource

问题描述

在这段代码中如何在没有为更新命令定义参数的情况下起作用?

how in this code, without define paramter for update command it working?

    <asp:SqlDataSource ID="SqlDataSource" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ShopConnectionString %>" 
            DeleteCommand="DELETE FROM [Company] WHERE [ID] = @ID" 
            InsertCommand="INSERT INTO [Company] ([Title], [Address]) VALUES (@Title, @Address)" 
            
            SelectCommand="SELECT [ID], [Title], [Address] FROM [Company]"  
            UpdateCommand="UPDATE [Company] SET [Title] = @Title, [Address] = @Address WHERE [ID] = @ID">
            <deleteparameters>
                <asp:Parameter Name="ID" Type="Int64" />    
            </deleteparameters>

            <%--<updateparameters>
                <asp:Parameter Name="Title" Type="String" />
                <asp:Parameter Name="Address" Type="String" />
                <asp:Parameter Name="ID" Type="Int64" />
            </updateparameters>
--%>
            <insertparameters>
                <asp:Parameter Name="Title" Type="String" />
                <asp:Parameter Name="Address" Type="String" />
            </insertparameters>

推荐答案

ConnectionStrings:ShopConnectionString％> DeleteCommand ="DELETE FROM [Company] WHERE [ID] = @ID" InsertCommand ="INSERT INTO [公司]([标题]，[地址])值(@Title，@Address)" SelectCommand ="SELECT [ID]，[Title]，[Address] FROM [Company]" UpdateCommand ="UPDATE [Company] SET [Title] = @Title，[Address] = @Address WHERE [ID] = @ID"> <删除参数> < asp:参数名称="ID"类型="Int64"/> </deleteparameters> <％-< updateparameters> < asp:参数名称=标题" Type ="String"/> < asp:参数名称=地址"类型=字符串"/> < asp:参数名称="ID"类型="Int64"/> </updateparameters> -％> <插入参数> < asp:参数名称=标题" Type ="String"/> < asp:参数名称=地址"类型=字符串"/> </insertparameters>

ConnectionStrings:ShopConnectionString %>" DeleteCommand="DELETE FROM [Company] WHERE [ID] = @ID" InsertCommand="INSERT INTO [Company] ([Title], [Address]) VALUES (@Title, @Address)" SelectCommand="SELECT [ID], [Title], [Address] FROM [Company]" UpdateCommand="UPDATE [Company] SET [Title] = @Title, [Address] = @Address WHERE [ID] = @ID"> <deleteparameters> <asp:Parameter Name="ID" Type="Int64" /> </deleteparameters> <%--<updateparameters> <asp:Parameter Name="Title" Type="String" /> <asp:Parameter Name="Address" Type="String" /> <asp:Parameter Name="ID" Type="Int64" /> </updateparameters> --%> <insertparameters> <asp:Parameter Name="Title" Type="String" /> <asp:Parameter Name="Address" Type="String" /> </insertparameters>

这取决于您要执行的操作，请参见

It depends on what you want to do, see Using Parameters with Data source[^]
More than likely you want to update from controls for the Title / name:

<Updateparameters>
  <asp:ControlParameter Name="Title" Type="String" controlid="DropDownListTitle" propertyname="SelectedValue"/>
  <asp:ControlParameter Name="Address" Type="String" controlid="nameTextBox" propertyname="Text"/>

</updateparameters>

至于ID，这在很大程度上取决于您如何设计表单，但更多的是您可能会从上面的ControlParameter或FormParameter或QueryStringParameter中获得它.示例可在链接中找到

As for the ID, that depends very much how you have designed the form, but more it is probably you''ll get it from ControlParameter as above or a FormParameter or a QueryStringParameter.Examples are available in the link above.

这篇关于定义SqlDataSource命令的参数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！