protected void GVIntro_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Del")
{
int row = Convert.ToInt32(e.CommandArgument);
string sqlStr = "delete from intro where ID=@id";
OleDbConnection con = new OleDbConnection(Constr);
con.Open();
OleDbCommand cmd = new OleDbCommand(sqlStr, con);
cmd.Parameters.AddWithValue("@id",row);
cmd.ExecuteNonQuery();
DisIntro();
lblmsg.ForeColor = System.Drawing.Color.Red;
lblmsg.Text = "信息删除成功";
}
}页面代码1:
<asp:TemplateField HeaderText="删除">
<ItemTemplate>
<asp:LinkButton ID="LinkButton1" runat="server" CommandArgument='<%# Eval("ID") %>'
CommandName="del" OnClientClick="return confirm('是否删除该行?');" Text="删除"></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>--------------------------------------------------------------------------------------
页面代码2:<asp:ButtonField CommandName="Del" DataTextField="ID" HeaderText="删除" />我在gridview 绑定一列删除的,以上是删除代码..但是运行后点击删除没有反应.以上两种页面代码我都试过了也删除不了.请问高手们是怎么会事呢.
{
if (e.CommandName == "Del")
{
int row = Convert.ToInt32(e.CommandArgument);
string sqlStr = "delete from intro where ID=@id";
OleDbConnection con = new OleDbConnection(Constr);
con.Open();
OleDbCommand cmd = new OleDbCommand(sqlStr, con);
cmd.Parameters.AddWithValue("@id",row);
cmd.ExecuteNonQuery();
DisIntro();
lblmsg.ForeColor = System.Drawing.Color.Red;
lblmsg.Text = "信息删除成功";
}
}页面代码1:
<asp:TemplateField HeaderText="删除">
<ItemTemplate>
<asp:LinkButton ID="LinkButton1" runat="server" CommandArgument='<%# Eval("ID") %>'
CommandName="del" OnClientClick="return confirm('是否删除该行?');" Text="删除"></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>--------------------------------------------------------------------------------------
页面代码2:<asp:ButtonField CommandName="Del" DataTextField="ID" HeaderText="删除" />我在gridview 绑定一列删除的,以上是删除代码..但是运行后点击删除没有反应.以上两种页面代码我都试过了也删除不了.请问高手们是怎么会事呢.
第二,如果执行了cmd.ExecuteNonQuery();
你用一个int i=cmd.ExecuteNonQuery();
这个,i=1时才删除成功,i=0时为删除失败.