我无法从Gridview中的数据库中删除数据

<asp:GridView ID="GridView1" runat="server" OnRowDeleting="GridView1_RowDeleting">
    <!-- 其他属性 -->
</asp:GridView>

protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
    // 获取要删除的行的ID
    int id = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value);

    // 执行删除操作
    string connectionString = ConfigurationManager.ConnectionStrings["YourConnectionString"].ConnectionString;
    using (SqlConnection conn = new SqlConnection(connectionString))
    {
        string query = "DELETE FROM YourTable WHERE Id = @Id";
        SqlCommand cmd = new SqlCommand(query, conn);
        cmd.Parameters.AddWithValue("@Id", id);
        conn.Open();
        cmd.ExecuteNonQuery();
    }

    // 刷新GridView
    BindGridView();
}

<asp:GridView ID="GridView1" runat="server" DataKeyNames="Id" OnRowDeleting="GridView1_RowDeleting">
    <Columns>
        <asp:TemplateField>
            <ItemTemplate>
                <asp:LinkButton ID="lnkDelete" runat="server" Text="Delete" CommandName="Delete" OnClientClick="return confirm('Are you sure you want to delete this record?');" />
            </ItemTemplate>
        </asp:TemplateField>
        <!-- 其他列 -->
    </Columns>
</asp:GridView>

protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
    int id = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value);
    string connectionString = ConfigurationManager.ConnectionStrings["YourConnectionString"].ConnectionString;
    using (SqlConnection conn = new SqlConnection(connectionString))
    {
        string query = "DELETE FROM YourTable WHERE Id = @Id";
        SqlCommand cmd = new SqlCommand(query, conn);
        cmd.Parameters.AddWithValue("@Id", id);
        conn.Open();
        cmd.ExecuteNonQuery();
    }
    BindGridView();
}

private void BindGridView()
{
    string connectionString = ConfigurationManager.ConnectionStrings["YourConnectionString"].ConnectionString;
    using (SqlConnection conn = new SqlConnection(connectionString))
    {
        string query = "SELECT * FROM YourTable";
        SqlCommand cmd = new SqlCommand(query, conn);
        conn.Open();
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataTable dt = new DataTable();
        da.Fill(dt);
        GridView1.DataSource = dt;
        GridView1.DataBind();
    }
}