更新和删除不在Girdview中工作 [英] Update and delete not Work in Girdview
本文介绍了更新和删除不在Girdview中工作的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我使用datasource对象来绑定网格以及编辑网格。绑定工作正常。但更新和删除不适合我。
这是我的代码。
I used datasource object to bind grid as well as edit grid. bind is work fine. but Update and delete not work for me.
This is my code .
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" CssClass="style1" DataKeyNames="_id" DataSourceID="SqlDataSource1">
<Columns>
<asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
<asp:BoundField DataField="_id" HeaderText="_id" InsertVisible="False" ReadOnly="True" SortExpression="_id" />
<asp:BoundField DataField="_videoName" HeaderText="_videoName" SortExpression="_videoName" />
<asp:BoundField DataField="_videoUrl" HeaderText="_videoUrl" SortExpression="_videoUrl" />
<asp:BoundField DataField="_category" HeaderText="_category" SortExpression="_category" />
<asp:BoundField DataField="_subCategory" HeaderText="_subCategory" SortExpression="_subCategory" />
<asp:BoundField DataField="_createdBy" HeaderText="_createdBy" SortExpression="_createdBy" />
<asp:BoundField DataField="_createdIp" HeaderText="_createdIp" SortExpression="_createdIp" />
<asp:BoundField DataField="_createTime" HeaderText="_createTime" SortExpression="_createTime" />
<asp:BoundField DataField="_modifyIp" HeaderText="_modifyIp" SortExpression="_modifyIp" />
<asp:BoundField DataField="_modifyTime" HeaderText="_modifyTime" SortExpression="_modifyTime" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConflictDetection="CompareAllValues" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
DeleteCommand="DELETE FROM [tbl_video] WHERE [_id] = @original_column1 AND (([_videoName] = @original_column2) OR ([_videoName] IS NULL AND @original_column2 IS NULL)) AND (([_videoUrl] = @original_column3) OR ([_videoUrl] IS NULL AND @original_column3 IS NULL)) AND (([_category] = @original_column4) OR ([_category] IS NULL AND @original_column4 IS NULL)) AND (([_subCategory] = @original_column5) OR ([_subCategory] IS NULL AND @original_column5 IS NULL)) AND (([_createdBy] = @original_column6) OR ([_createdBy] IS NULL AND @original_column6 IS NULL)) AND (([_createdIp] = @original_column7) OR ([_createdIp] IS NULL AND @original_column7 IS NULL)) AND (([_createTime] = @original_column8) OR ([_createTime] IS NULL AND @original_column8 IS NULL)) AND (([_modifyIp] = @original_column9) OR ([_modifyIp] IS NULL AND @original_column9 IS NULL)) AND (([_modifyTime] = @original_column10) OR ([_modifyTime] IS NULL AND @original_column10 IS NULL))"
InsertCommand="INSERT INTO [tbl_video] ([_videoName], [_videoUrl], [_category], [_subCategory], [_createdBy], [_createdIp], [_createTime], [_modifyIp], [_modifyTime]) VALUES (@column1, @column2, @column3, @column4, @column5, @column6, @column7, @column8, @column9)" OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT * FROM [tbl_video]"
UpdateCommand="UPDATE [tbl_video] SET [_videoName] = @column1, [_videoUrl] = @column2, [_category] = @column3, [_subCategory] = @column4, [_createdBy] = @column5, [_createdIp] = @column6, [_createTime] = @column7, [_modifyIp] = @column8, [_modifyTime] = @column9 WHERE [_id] = @original_column1 AND (([_videoName] = @original_column2) OR ([_videoName] IS NULL AND @original_column2 IS NULL)) AND (([_videoUrl] = @original_column3) OR ([_videoUrl] IS NULL AND @original_column3 IS NULL)) AND (([_category] = @original_column4) OR ([_category] IS NULL AND @original_column4 IS NULL)) AND (([_subCategory] = @original_column5) OR ([_subCategory] IS NULL AND @original_column5 IS NULL)) AND (([_createdBy] = @original_column6) OR ([_createdBy] IS NULL AND @original_column6 IS NULL)) AND (([_createdIp] = @original_column7) OR ([_createdIp] IS NULL AND @original_column7 IS NULL)) AND (([_createTime] = @original_column8) OR ([_createTime] IS NULL AND @original_column8 IS NULL)) AND (([_modifyIp] = @original_column9) OR ([_modifyIp] IS NULL AND @original_column9 IS NULL)) AND (([_modifyTime] = @original_column10) OR ([_modifyTime] IS NULL AND @original_column10 IS NULL))">
<DeleteParameters>
<asp:Parameter Name="original_column1" Type="Int32" />
<asp:Parameter Name="original_column2" Type="String" />
<asp:Parameter Name="original_column3" Type="String" />
<asp:Parameter Name="original_column4" Type="String" />
<asp:Parameter Name="original_column5" Type="String" />
<asp:Parameter Name="original_column6" Type="String" />
<asp:Parameter Name="original_column7" Type="String" />
<asp:Parameter Name="original_column8" Type="String" />
<asp:Parameter Name="original_column9" Type="String" />
<asp:Parameter Name="original_column10" Type="String" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="column1" Type="String" />
<asp:Parameter Name="column2" Type="String" />
<asp:Parameter Name="column3" Type="String" />
<asp:Parameter Name="column4" Type="String" />
<asp:Parameter Name="column5" Type="String" />
<asp:Parameter Name="column6" Type="String" />
<asp:Parameter Name="column7" Type="String" />
<asp:Parameter Name="column8" Type="String" />
<asp:Parameter Name="column9" Type="String" />
<asp:Parameter Name="original_column1" Type="Int32" />
<asp:Parameter Name="original_column2" Type="String" />
<asp:Parameter Name="original_column3" Type="String" />
<asp:Parameter Name="original_column4" Type="String" />
<asp:Parameter Name="original_column5" Type="String" />
<asp:Parameter Name="original_column6" Type="String" />
<asp:Parameter Name="original_column7" Type="String" />
<asp:Parameter Name="original_column8" Type="String" />
<asp:Parameter Name="original_column9" Type="String" />
<asp:Parameter Name="original_column10" Type="String" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="column1" Type="String" />
<asp:Parameter Name="column2" Type="String" />
<asp:Parameter Name="column3" Type="String" />
<asp:Parameter Name="column4" Type="String" />
<asp:Parameter Name="column5" Type="String" />
<asp:Parameter Name="column6" Type="String" />
<asp:Parameter Name="column7" Type="String" />
<asp:Parameter Name="column8" Type="String" />
<asp:Parameter Name="column9" Type="String" />
</InsertParameters>
</asp:SqlDataSource>
推荐答案
ConnectionStrings：ConnectionString％>
DeleteCommand = DELETE FROM [tbl_video] WHERE [_id] = @ original_column1 AND（（[_ videoName] = @ original_column2）OR（[_ videoName] IS NULL AND @ original_column2 IS NULL））AND（（[_ videoUrl] = @ original_column3）OR（[_ videoUrl] IS NULL AND @ original_column3 IS NULL））AND（（[_category] = @ original_column4）OR（[_category] IS NULL AND @ original_column4 IS NULL））AND（（[_ subCategory] = @ original_column5）OR（[_ subCategory] IS NULL AND @ original_column5 IS NULL））AND（（[_ createBy] = @original_col umn6）OR（[_ createBy] IS NULL和@ original_column6 IS NULL））AND（（[_ createIp] = @ original_column7）OR（[_ createIp] IS NULL AND @ original_column7 IS NULL））AND（（[_ createTime] = @ original_column8） OR（[_ createTime] IS NULL和@ original_column8 IS NULL））AND（（[_modifyIp] = @ original_column9）OR（[_modifyIp] IS NULL AND @ original_column9 IS NULL））AND（（[_modifyTime] = @ original_column10）OR（ [_modifyTime] IS NULL AND @ original_column10 IS NULL））
InsertCommand = INSERT INTO [tbl_video]（[_ videoName]，[_ videoUrl]，[_ category]，[_ subCategory]，[_ createBy]，[_ createIp]，[_ createTime]，[_ modifyIp]，[_ modifyTime]）VALUES（@ column1，@ column2，@ column3 ，@ column4，@ column5，@ column6，@ column7，@ column8，@ column9） OldValuesParameterFormatString = original_ {0} SelectCommand = SELECT * FROM [tbl_video]
UpdateCommand = UPDATE [tbl_video] SET [_videoName] = @ column1，[_ videoUrl] = @ column2，[_ category] = @ column3，[_ subCategory] = @ column4，[_ createBy] = @ column5，[_ createIp] = @ column6，[_ createTime] = @ column7，[ _modifyIp] = @ column8，[_ modifyTime] = @ column9 WHERE [_id] = @ original_column1 AND（（[_ videoName] = @ original_column2）OR（[_ videoName] IS NULL AND @ original_column2 IS NULL））AND（（[_videoUrl] = @ original_column3）OR（[_ videoUrl] IS NULL AND @ original_column3 IS NULL））AND（（[_category] = @ original_column4）OR（[_category] IS NULL AND @ original_column4 IS NULL））AND（（[_ subCategory] = @ original_column5 ）OR（[_ subCategory] IS NULL和@ original_column5 IS NULL））AND（（[_ createBy] = @ original_column6）OR（[_ createBy] IS NULL AND @ original_column6 IS NULL））AND（（[_createdIp] = @ original_column7）OR （[_createdIp]为空，@ original_column7为空））AND（（[_ createTime] = @ original_column8）OR（[_ createTime] IS NULL AND @ original_column8 IS NULL））AND（（[_modifyIp] = @ original_column9）OR（[_modifyIp] IS NULL AND @ original_column9 IS NULL）） AND（（[_modifyTime] = @ original_column10）OR（[_ modifyTime] IS NULL AND @ original_column10 IS NULL）） >
< ; DeleteParameters>
< asp：参数名称= original_column1 Type = Int32 />
< asp：参数名称= original_column2 Type = String />
< asp：参数名称= original_column3 Type = String />
< asp：参数名称= original_column4 Type = String />
< asp：参数名称= original_column5 Type = String />
< asp：参数名称= original_column6 Type = String />
< asp：参数名称= original_column7 Type = String />
< asp：参数名称= original_column8 Type = String />
< asp：参数名称= original_column9 Type = String />
< asp：参数名称= original_column10 Type = String />
< / DeleteParameters >
< UpdateParameters>
< asp：参数名称= column1 Type = String />
< asp：参数名称= column2 Type = String />
< asp：参数名称= column3 Type = String />
< asp：参数名称= column4 Type = String />
< asp：参数名称= column5 Type = String />
< asp：参数名称= column6 Type = String />
< asp：参数名称= column7 Type = String />
< asp：参数名称= column8 Type = String />
< asp：参数名称= column9 Type = String />
< asp：参数名称= original_column1 Type = Int32 />
< asp：参数名称= original_column2 Type = String />
< asp：参数名称= original_column3 Type = String />
< asp：参数名称= original_column4 Type = String />
< asp：参数名称= original_column5 Type = String />
< asp：参数名称= original_column6 Type = String />
< asp：参数名称= original_column7 Type = String />
< asp：参数名称= original_column8 Type = String />
< asp：参数名称= original_column9 Type = String />
< asp：参数名称= original_column10 Type = String />
< / UpdateParameters >
< InsertParameters>
< asp：参数名称= column1 Type = String />
< asp：参数名称= column2 Type = String />
< asp：参数名称= column3 Type = String />
< asp：参数名称= column4 Type = String />
< asp：参数名称= column5 Type = String />
< asp：参数名称= column6 Type = String />
< asp：参数名称= column7 Type = String />
< asp：参数名称= column8 Type = String />
< asp：参数名称= column9 Type = String />
< / InsertParameters >
< / asp：SqlDataSource >
ConnectionStrings:ConnectionString %>" DeleteCommand="DELETE FROM [tbl_video] WHERE [_id] = @original_column1 AND (([_videoName] = @original_column2) OR ([_videoName] IS NULL AND @original_column2 IS NULL)) AND (([_videoUrl] = @original_column3) OR ([_videoUrl] IS NULL AND @original_column3 IS NULL)) AND (([_category] = @original_column4) OR ([_category] IS NULL AND @original_column4 IS NULL)) AND (([_subCategory] = @original_column5) OR ([_subCategory] IS NULL AND @original_column5 IS NULL)) AND (([_createdBy] = @original_column6) OR ([_createdBy] IS NULL AND @original_column6 IS NULL)) AND (([_createdIp] = @original_column7) OR ([_createdIp] IS NULL AND @original_column7 IS NULL)) AND (([_createTime] = @original_column8) OR ([_createTime] IS NULL AND @original_column8 IS NULL)) AND (([_modifyIp] = @original_column9) OR ([_modifyIp] IS NULL AND @original_column9 IS NULL)) AND (([_modifyTime] = @original_column10) OR ([_modifyTime] IS NULL AND @original_column10 IS NULL))" InsertCommand="INSERT INTO [tbl_video] ([_videoName], [_videoUrl], [_category], [_subCategory], [_createdBy], [_createdIp], [_createTime], [_modifyIp], [_modifyTime]) VALUES (@column1, @column2, @column3, @column4, @column5, @column6, @column7, @column8, @column9)" OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT * FROM [tbl_video]" UpdateCommand="UPDATE [tbl_video] SET [_videoName] = @column1, [_videoUrl] = @column2, [_category] = @column3, [_subCategory] = @column4, [_createdBy] = @column5, [_createdIp] = @column6, [_createTime] = @column7, [_modifyIp] = @column8, [_modifyTime] = @column9 WHERE [_id] = @original_column1 AND (([_videoName] = @original_column2) OR ([_videoName] IS NULL AND @original_column2 IS NULL)) AND (([_videoUrl] = @original_column3) OR ([_videoUrl] IS NULL AND @original_column3 IS NULL)) AND (([_category] = @original_column4) OR ([_category] IS NULL AND @original_column4 IS NULL)) AND (([_subCategory] = @original_column5) OR ([_subCategory] IS NULL AND @original_column5 IS NULL)) AND (([_createdBy] = @original_column6) OR ([_createdBy] IS NULL AND @original_column6 IS NULL)) AND (([_createdIp] = @original_column7) OR ([_createdIp] IS NULL AND @original_column7 IS NULL)) AND (([_createTime] = @original_column8) OR ([_createTime] IS NULL AND @original_column8 IS NULL)) AND (([_modifyIp] = @original_column9) OR ([_modifyIp] IS NULL AND @original_column9 IS NULL)) AND (([_modifyTime] = @original_column10) OR ([_modifyTime] IS NULL AND @original_column10 IS NULL))"> <DeleteParameters> <asp:Parameter Name="original_column1" Type="Int32" /> <asp:Parameter Name="original_column2" Type="String" /> <asp:Parameter Name="original_column3" Type="String" /> <asp:Parameter Name="original_column4" Type="String" /> <asp:Parameter Name="original_column5" Type="String" /> <asp:Parameter Name="original_column6" Type="String" /> <asp:Parameter Name="original_column7" Type="String" /> <asp:Parameter Name="original_column8" Type="String" /> <asp:Parameter Name="original_column9" Type="String" /> <asp:Parameter Name="original_column10" Type="String" /> </DeleteParameters> <UpdateParameters> <asp:Parameter Name="column1" Type="String" /> <asp:Parameter Name="column2" Type="String" /> <asp:Parameter Name="column3" Type="String" /> <asp:Parameter Name="column4" Type="String" /> <asp:Parameter Name="column5" Type="String" /> <asp:Parameter Name="column6" Type="String" /> <asp:Parameter Name="column7" Type="String" /> <asp:Parameter Name="column8" Type="String" /> <asp:Parameter Name="column9" Type="String" /> <asp:Parameter Name="original_column1" Type="Int32" /> <asp:Parameter Name="original_column2" Type="String" /> <asp:Parameter Name="original_column3" Type="String" /> <asp:Parameter Name="original_column4" Type="String" /> <asp:Parameter Name="original_column5" Type="String" /> <asp:Parameter Name="original_column6" Type="String" /> <asp:Parameter Name="original_column7" Type="String" /> <asp:Parameter Name="original_column8" Type="String" /> <asp:Parameter Name="original_column9" Type="String" /> <asp:Parameter Name="original_column10" Type="String" /> </UpdateParameters> <InsertParameters> <asp:Parameter Name="column1" Type="String" /> <asp:Parameter Name="column2" Type="String" /> <asp:Parameter Name="column3" Type="String" /> <asp:Parameter Name="column4" Type="String" /> <asp:Parameter Name="column5" Type="String" /> <asp:Parameter Name="column6" Type="String" /> <asp:Parameter Name="column7" Type="String" /> <asp:Parameter Name="column8" Type="String" /> <asp:Parameter Name="column9" Type="String" /> </InsertParameters> </asp:SqlDataSource>
请尝试使用以下代码进行更新
Please try with the following code for Update
UPDATE [tbl_video]
SET [_videoName] = @_videoName, [_videoUrl] = @_videoUrl, [_category] = @_category,
[_subCategory] = @_subCategory, [_createdBy] = @_createdBy,
[_createdIp] = @_createdIp, [_createTime] = @_createTime,
[_modifyIp] = @_modifyIp, [_modifyTime] = @_modifyTime
WHERE [_id] = @original__id
同样对于删除，您可以尝试使用以下代码：
Similarly for Delete you can try with the following code:
DELETE FROM [tbl_video]
WHERE [_id] = @original__id
这篇关于更新和删除不在Girdview中工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
