我在gridview中添加的编辑和删除按钮,与gridview相连的sqldatasource控件做了下面的设置,
<asp:SqlDataSource
ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:dflicapp %>"
DeleteCommand="DELETE FROM [wlpj22007] WHERE [wlno] = @wlno"
InsertCommand="INSERT INTO [wlpj22007] ([uid], [wlno], [wssite], [wldp], [wldm], [nt], [dyld], [csll], [sjbcsm]) VALUES (@uid, @wlno, @wssite, @wldp, @wldm, @nt, @dyld, @csll, @sjbcsm)"
SelectCommand="SELECT * FROM [wlpj22007]"
UpdateCommand="UPDATE [wlpj22007] SET [uid] = @uid, [wssite] = @wssite, [wldp] = @wldp, [wldm] = @wldm, [nt] = @nt, [dyld] = @dyld, [csll] = @csll, [sjbcsm] = @sjbcsm WHERE [wlno] = @wlno">
<DeleteParameters>
<asp:Parameter Name="wlno" Type="String" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="uid" Type="String" />
<asp:Parameter Name="wssite" Type="String" />
<asp:Parameter Name="wldp" Type="Decimal" />
<asp:Parameter Name="wldm" Type="Decimal" />
<asp:Parameter Name="nt" Type="String" />
<asp:Parameter Name="dyld" Type="Decimal" />
<asp:Parameter Name="csll" Type="Decimal" />
<asp:Parameter Name="sjbcsm" Type="String" />
<asp:Parameter Name="wlno" Type="String" />
</UpdateParameters>
<InsertParameters>
<asp:ControlParameter ControlID="uid" Name="uid" PropertyName="Text" Type="String" />
<asp:ControlParameter ControlID="wlno" Name="wlno" PropertyName="Text" Type="String" />
<asp:ControlParameter ControlID="wssite" Name="wssite" PropertyName="Text" Type="String" />
<asp:ControlParameter ControlID="wldp" Name="wldp" PropertyName="Text" Type="Decimal" />
<asp:ControlParameter ControlID="wldm" Name="wldm" PropertyName="Text" Type="Decimal" />
<asp:ControlParameter ControlID="nt" Name="nt" PropertyName="Text" Type="String" />
<asp:ControlParameter ControlID="dyld" Name="dyld" PropertyName="Text" Type="Decimal" />
<asp:ControlParameter ControlID="csll" Name="csll" PropertyName="Text" Type="Decimal" />
<asp:ControlParameter ControlID="sjbcsm" Name="sjbcsm" PropertyName="Text" Type="String" />
</InsertParameters>
</asp:SqlDataSource>当我使用gridview的删除或者编辑功能时,总是提示错误:必须声明标量变量 "@wlno"。
我应该怎么修改啊?
<asp:SqlDataSource
ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:dflicapp %>"
DeleteCommand="DELETE FROM [wlpj22007] WHERE [wlno] = @wlno"
InsertCommand="INSERT INTO [wlpj22007] ([uid], [wlno], [wssite], [wldp], [wldm], [nt], [dyld], [csll], [sjbcsm]) VALUES (@uid, @wlno, @wssite, @wldp, @wldm, @nt, @dyld, @csll, @sjbcsm)"
SelectCommand="SELECT * FROM [wlpj22007]"
UpdateCommand="UPDATE [wlpj22007] SET [uid] = @uid, [wssite] = @wssite, [wldp] = @wldp, [wldm] = @wldm, [nt] = @nt, [dyld] = @dyld, [csll] = @csll, [sjbcsm] = @sjbcsm WHERE [wlno] = @wlno">
<DeleteParameters>
<asp:Parameter Name="wlno" Type="String" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="uid" Type="String" />
<asp:Parameter Name="wssite" Type="String" />
<asp:Parameter Name="wldp" Type="Decimal" />
<asp:Parameter Name="wldm" Type="Decimal" />
<asp:Parameter Name="nt" Type="String" />
<asp:Parameter Name="dyld" Type="Decimal" />
<asp:Parameter Name="csll" Type="Decimal" />
<asp:Parameter Name="sjbcsm" Type="String" />
<asp:Parameter Name="wlno" Type="String" />
</UpdateParameters>
<InsertParameters>
<asp:ControlParameter ControlID="uid" Name="uid" PropertyName="Text" Type="String" />
<asp:ControlParameter ControlID="wlno" Name="wlno" PropertyName="Text" Type="String" />
<asp:ControlParameter ControlID="wssite" Name="wssite" PropertyName="Text" Type="String" />
<asp:ControlParameter ControlID="wldp" Name="wldp" PropertyName="Text" Type="Decimal" />
<asp:ControlParameter ControlID="wldm" Name="wldm" PropertyName="Text" Type="Decimal" />
<asp:ControlParameter ControlID="nt" Name="nt" PropertyName="Text" Type="String" />
<asp:ControlParameter ControlID="dyld" Name="dyld" PropertyName="Text" Type="Decimal" />
<asp:ControlParameter ControlID="csll" Name="csll" PropertyName="Text" Type="Decimal" />
<asp:ControlParameter ControlID="sjbcsm" Name="sjbcsm" PropertyName="Text" Type="String" />
</InsertParameters>
</asp:SqlDataSource>当我使用gridview的删除或者编辑功能时,总是提示错误:必须声明标量变量 "@wlno"。
我应该怎么修改啊?
加上Declare @wlno varchar(500)