c# - 多个删除功能在转发器控件中只删除一行

Question

我有 2 个转发器控件，一个在另一个里面，实际上我正在显示来自两个不同表的内容，我为每一行添加了复选框以使用单击按钮删除多行，但是在选择多个复选框后删除查询只删除一行一次。我只是在转发器控制下添加了 checkobx，我试图找出异常但堆栈没有显示它!以下是我的代码隐藏:

protected void btnDeleteNews_Click(object sender, EventArgs e)
{

    foreach (RepeaterItem item in rptMainBlock.Items)
    {

        if ((item.FindControl("chkDel") as CheckBox).Checked)
        {
            string newsId = (item.FindControl("lblNewsId") as Label).Text;
            cmd = new SqlCommand("DELETE FROM newsImageGal where newsId IN (SELECT newsId from news where newsId=@newsId);DELETE from news where newsId=@newsId", con);
            con.Open();
            cmd.Parameters.AddWithValue("@newsId", newsId);
            cmd.ExecuteNonQuery();

            this.Page.ClientScript.RegisterStartupScript(this.GetType(), "ex", "alert('Selected News Deleted Successfully');", true);
            con.Close();
            Response.Redirect("deleteNews.aspx");

        }
        else
        {
            this.Page.ClientScript.RegisterStartupScript(this.GetType(), "ex", "alert('No Data Deleted');", true);
        }
    }

}

请告诉我为什么会这样。

Answer 1

问题是您在循环中重定向:

foreach (RepeaterItem item in rptMainBlock.Items)
{
    // delete ..
    Response.Redirect("deleteNews.aspx");  // aborts this thread and ends the page's life-cycle
}

我假设您只想在最后执行一次:

foreach (RepeaterItem item in rptMainBlock.Items)
{
    // delete ..
}
Response.Redirect("deleteNews.aspx");

但是，当您重定向到另一个页面时，alert('Selected News Deleted Successfully'); 也毫无意义。