当前位置：首页 > 行业动态 > 正文

ASP.NET删除DataGrid记录弹出提示信息如何实现？

admin
行业动态
2025-03-08
4

“

csharp，protected void DeleteButton_Click(object sender, EventArgs e)，{， // 获取要删除的记录ID， int recordId = Convert.ToInt32((sender as Button).CommandArgument); // 从数据库中删除记录， using (SqlConnection con = new SqlConnection(connectionString))， {， string query = "DELETE FROM TableName WHERE ID = @ID";， using (SqlCommand cmd = new SqlCommand(query, con))， {， cmd.Parameters.AddWithValue("@ID", recordId);， con.Open();， int result = cmd.ExecuteNonQuery();， if (result > 0)， {， ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Record deleted successfully!');", true);， }， else， {， ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Failed to delete record.');", true);， }， }， }，}，

“

在ASP.NET中实现删除DataGrid记录时弹出提示信息，可以通过以下步骤完成：

准备工作

确保你已经有一个ASP.NET Web应用程序项目，并且已经添加了一个DataGrid控件（例如GridView）到你的页面，假设你的DataGrid绑定到一个数据源，比如一个数据库表。

前端设计

在你的ASPX页面上，添加一个GridView控件和一个按钮用于删除选中的行。

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="DeleteRecord.aspx.cs" Inherits="DeleteRecord" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>删除DataGrid记录</title>
    <script type="text/javascript">
        function confirmDelete() {
            if (confirm("你确定要删除所选记录吗？")) {
                return true;
            } else {
                return false;
            }
        }
    </script>
</head>
<body>
    <form id="form1" runat="server">
        <div>
            <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="ID">
                <Columns>
                    <asp:BoundField DataField="ID" HeaderText="ID" />
                    <asp:BoundField DataField="Name" HeaderText="名称" />
                    <asp:CommandField ShowDeleteButton="True" />
                </Columns>
            </asp:GridView>
            <asp:Button ID="DeleteButton" runat="server" Text="删除选中行" OnClientClick="return confirmDelete();" OnClick="DeleteButton_Click" />
        </div>
    </form>
</body>
</html>

后端代码

在DeleteRecord.aspx.cs文件中，处理删除操作的逻辑。

ASP.NET删除DataGrid记录弹出提示信息如何实现？

using System;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
public partial class DeleteRecord : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            BindGrid();
        }
    }
    private void BindGrid()
    {
        string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
        using (SqlConnection con = new SqlConnection(constr))
        {
            using (SqlCommand cmd = new SqlCommand("SELECT  FROM YourTableName"))
            {
                using (SqlDataAdapter sda = new SqlDataAdapter())
                {
                    cmd.Connection = con;
                    sda.SelectCommand = cmd;
                    using (DataTable dt = new DataTable())
                    {
                        sda.Fill(dt);
                        GridView1.DataSource = dt;
                        GridView1.DataBind();
                    }
                }
            }
        }
    }
    protected void DeleteButton_Click(object sender, EventArgs e)
    {
        foreach (GridViewRow row in GridView1.Rows)
        {
            CheckBox chkBx = (row.FindControl("chkDelete") as CheckBox);
            if (chkBx != null && chkBx.Checked)
            {
                int id = int.Parse(GridView1.DataKeys[row.RowIndex].Value.ToString());
                DeleteRecordByID(id);
            }
        }
        BindGrid();
    }
    private void DeleteRecordByID(int id)
    {
        string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
        using (SqlConnection con = new SqlConnection(constr))
        {
            using (SqlCommand cmd = new SqlCommand("DELETE FROM YourTableName WHERE ID=@ID"))
            {
                cmd.Parameters.AddWithValue("@ID", id);
                con.Open();
                cmd.ExecuteNonQuery();
            }
        }
        ScriptManager.RegisterStartupScript(this, GetType(), "alert", "alert('记录已成功删除！');", true);
    }
}