批量删除按钮事件
int hs = 0;
for (int i = 0; i < this.Repeater1.Items.Count; i++)
{
if (((CheckBox)(this.Repeater1.Items[i].FindControl("ck1"))).Checked == true)
{
hs++;
}
}
if (hs == 0)
{
Response.Write("<script>alert('您还未选择要删除的行!!')</script>");
}
else
{
StringBuilder sb = new StringBuilder();
for (int i = 0; i < this.Repeater1.Items.Count; i++)
{
if (((CheckBox)(this.Repeater1.Items[i].FindControl("ck1"))).Checked == true)
{
string a = ((HiddenField)(this.Repeater1.Items[i].FindControl("HiddenField1"))).Value.ToString();
sb.Append(" Id=");
sb.Append("'" + a + "'");
sb.Append(" or ");
}
}
sb.Append("Id='' ");
if (Web.BLL.UserManager.UserPLDeles(sb.ToString()))
{
Response.Redirect("UserMann.aspx");
}
}
批量删除的存储过程
ALTER PROCEDURE [dbo].[Pro_DeletePL]
@stringid nvarchar(500)
AS
BEGIN
declare @sql varchar(200)
select @sql='Delete from Table_User where '+@stringid
exec(@sql)
END