asp.net问题。我删除一条数据库记录用这条语句看是否成功int count = cmd.ExecuteNonQuery();但是有错

如果StudentID是int类型的话，那么sql是：delete from StudentCourse where StudentID="+StudentID+" and CourseName='语文'"

注意如果是varchar类型，一定要加单引号，CourseName是varchar吧，所以语文要加单引号

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>

---