datagrid server_datagrid lienceserver-优快云博客

本文链接：https://blog.youkuaiyun.com/jojozhuang/article/details/1383323

本文介绍如何在ASP.NET的DataGrid控件中实现删除功能，包括设置删除按钮、处理删除命令、执行删除操作及确认提示等步骤。具体展示了通过DataGrid的ItemCommand事件来响应删除操作，并通过SQL命令从数据库中移除对应记录的方法。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

<asp:TemplateColumn>

<asp:LinkButton id="btnDelete" runat="server" CommandName="Delete" Text="削除"></asp:LinkButton>

</ItemTemplate>

</asp:TemplateColumn>

private void DataGrid1_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
  {
   this.DeleteRow(this.DataGrid1.DataKeys[e.Item.ItemIndex].ToString());
  }

  private void DataGrid1_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
  {
   if(e.CommandName == "Delete")
   {
    //this.DeleteRow(this.DataGrid1.DataKeys[e.Item.ItemIndex].ToString());
   }
  }
  private void DeleteRow(string i)
  {
//   string mySelectQuery = "DELETE FROM userinfo where userid=" + i;
//   string myConnectString = "Initial Catalog=testDb;server=ZHUANGRONG;Integrated Security=false;user id=testuser; Pwd=testuser";
//   SqlDataAdapter myDataAdapter = new SqlDataAdapter();
//   SqlConnection myConnection = new SqlConnection(myConnectString);
//   myConnection.Open();
//   SqlCommand myCommand = new SqlCommand(mySelectQuery, myConnection);
//   myCommand.ExecuteNonQuery();
//   myConnection.Close();
//   BindData();
  }

  private void DataGrid1_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
  {
   string strUserId = this.DataGrid1.DataKeys[e.Item.ItemIndex].ToString();
   Response.Redirect("WebForm3.aspx?UserId="+strUserId);

  }

  private void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
  {
   LinkButton btn = (LinkButton)e.Item.FindControl("btnDelete");
   if(btn != null)
   {
    btn.Attributes.Add("onclick", "return confirm('re u sure to delete it?');");
   }
  }