Question

我想用asp.net中的gridview控件来删除数据库中的记录，如何实现？

protected void gvShow_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
new Es.BLL.DataUpdate().deleteVideo("delete from video where vid='" + gvShow.DataKeys[e.RowIndex].Value.ToString() + "'");
gvShow.DataBind();
}
这么写，，一直提示我 索引超出范围，必须为非负值并小于集合大小。

Answer 1

protected void gdv_Announce_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string keyword = gdv_Announce.DataKeys[e.RowIndex].Value.ToString();
string sql_del = "delete from tsmannouncementmanage where id=" + keyword;
dbCon.deleteData(sql_del);
DataBindTogdv_Announce("order by id desc");
}

datakeynames要设置成id

<asp:GridView ID="gdv_Announce" runat="server" AutoGenerateColumns="False" CellPadding="4"
GridLines="None" PageSize="5" Style="font-size: 12px" Width="100%" OnRowDataBound="gdv_Announce_RowDataBound"
OnRowDeleting="gdv_Announce_RowDeleting" DataKeyNames="Id" ForeColor="Black"
AllowPaging="True">

<asp:TemplateField HeaderText="删除">
<EditItemTemplate>
<asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>
</EditItemTemplate>
<HeaderStyle BackColor="#99CCFF" ForeColor="Black" Wrap="False" />
<ItemTemplate>
<asp:LinkButton ID="LinkButton1" runat="server" CommandName="delete">删除</asp:LinkButton> 
</ItemTemplate>
</asp:TemplateField>

Answer 2

dataview 中 DataKeyNames的属性你没有设置吧？设置成你要查询的条件的字段名。