通过对DetailsView的AutoGenerateDeleteButton属性设置为true来自动生成删除按钮.
<asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False" DataSourceID="SqlDataSource1"
Height="50px" Width="125px" AutoGenerateDeleteButton="True" AutoGenerateEditButton="True"
AutoGenerateInsertButton="True" AllowPaging="True" OnItemCreated="DetailsView1_ItemCreated"
OnItemDeleted="DetailsView1_ItemDeleted" >
</asp:DetailsView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$
ConnectionStrings:aConnectionString>"
SelectCommand="SELECT * FROM [aa]"
DeleteCommand="DELETE FROM [aa] WHERE [a] = @a"
InsertCommand="INSERT INTO [aa] ([a], [b],[c]) VALUES (@a, @b, @c)"
UpdateCommand="UPDATE [aa] SET [b] = @b, [c] = @c WHERE [a] = @a">
<DeleteParameters>
<asp:Parameter Name="a" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="b" Type="Int32" />
<asp:Parameter Name="c" Type="Int32" />
<asp:Parameter Name="a" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="a" Type="Int32" />
<asp:Parameter Name="b" Type="Int32" />
<asp:Parameter Name="c" Type="Int32" />
</InsertParameters>
</asp:SqlDataSource>
为什么编辑,新建和更新都没问题,就在删除时出错,提示"必须声明标量变量 '@a'。 ".
如果我把 DeleteCommand="DELETE FROM [aa] WHERE [a] = @a" 改成
DeleteCommand="DELETE FROM [aa] WHERE [a] = @ab"
把
<DeleteParameters>
<asp:Parameter Name="a" Type="Int32" />
</DeleteParameters>
改成
<DeleteParameters>
<asp:Parameter Name="ab" Type="Int32" />
</DeleteParameters>
则在删除时不出错,但没任何反应,数据库中数据没有任何变化.
请高手解决.谢谢.
<asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False" DataSourceID="SqlDataSource1"
Height="50px" Width="125px" AutoGenerateDeleteButton="True" AutoGenerateEditButton="True"
AutoGenerateInsertButton="True" AllowPaging="True" OnItemCreated="DetailsView1_ItemCreated"
OnItemDeleted="DetailsView1_ItemDeleted" >
</asp:DetailsView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$
ConnectionStrings:aConnectionString>"
SelectCommand="SELECT * FROM [aa]"
DeleteCommand="DELETE FROM [aa] WHERE [a] = @a"
InsertCommand="INSERT INTO [aa] ([a], [b],[c]) VALUES (@a, @b, @c)"
UpdateCommand="UPDATE [aa] SET [b] = @b, [c] = @c WHERE [a] = @a">
<DeleteParameters>
<asp:Parameter Name="a" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="b" Type="Int32" />
<asp:Parameter Name="c" Type="Int32" />
<asp:Parameter Name="a" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="a" Type="Int32" />
<asp:Parameter Name="b" Type="Int32" />
<asp:Parameter Name="c" Type="Int32" />
</InsertParameters>
</asp:SqlDataSource>
为什么编辑,新建和更新都没问题,就在删除时出错,提示"必须声明标量变量 '@a'。 ".
如果我把 DeleteCommand="DELETE FROM [aa] WHERE [a] = @a" 改成
DeleteCommand="DELETE FROM [aa] WHERE [a] = @ab"
把
<DeleteParameters>
<asp:Parameter Name="a" Type="Int32" />
</DeleteParameters>
改成
<DeleteParameters>
<asp:Parameter Name="ab" Type="Int32" />
</DeleteParameters>
则在删除时不出错,但没任何反应,数据库中数据没有任何变化.
请高手解决.谢谢.
解决方案 »
- window.open( "open.html ", "窗口名","")
- 【真心高分求教】我这个服务器配置、内容,该不该装硬件防火墙?
- 提示框点击取消的同时执行方法
- flexigrid显示WCF返回Json数据问题。
- 请问在GridView中使用DropDownList控件,databindings中的selectvalue如何写
- 求救:如何根据下拉框选择的内容动态绑定DataGrid某列的HeadText文本
- ASP.NET建网求助
- 关于select2 插件的数据获取。
- 各位大哥,能告诉我左边的treeview的关闭按钮是怎么做出来的么?怎么样才能作出那样的效果?
- 新手求助~~~
- 电脑加一内存问题~~
- 即时信息通知
Height="50px" Width="125px" AutoGenerateDeleteButton="True" AutoGenerateEditButton="True"
AutoGenerateInsertButton="True" AllowPaging="True" OnItemCreated="DetailsView1_ItemCreated"
OnItemDeleted="DetailsView1_ItemDeleted" DataKeyNames="a">
</asp:DetailsView>