Repeater获取勾选数据，拼接成SQL实现批量删除+存储过程

来源：互联网发布：如何让安卓手机连入mac 编辑：程序博客网时间：2024/05/18 01:13

批量删除按钮事件

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

0 0