.Net实现的批量删除(使用了repeater控件)
2024-08-25 00:43:29
前台
<asp:Repeater ID="Repeater1" runat="server">
<HeaderTemplate>
<table>
<tr>
<td>选择</td>
<td>姓名</td>
<td>密码</td>
</tr> </HeaderTemplate>
<ItemTemplate>
<tr>
<td><input id="CKChance" runat="server" type="checkbox" value='<%#Eval("AdminId") %>'/></td>
<td><%#Eval("AdminName") %></td>
<td><%#Eval("AdminPwd") %></td>
</tr>
</ItemTemplate>
<FooterTemplate>
</table>
</FooterTemplate>
</asp:Repeater> <asp:Button ID="Button1" runat="server" Text="Button" OnClick="Button1_Click" />
后台:
protected void Page_Load(object sender, EventArgs e)
{
if(!IsPostBack)
{
GetDate();
}
} public void GetDate()
{
string ConStr = "Data Source=.;Initial Catalog=UserSystem;Integrated Security=True";
using (SqlConnection conn = new SqlConnection(ConStr))
{
string sql = "SELECT * FROM ADMIN";
//SqlCommand comm = new SqlCommand(sql.ToString(),conn);
DataSet dt = new DataSet();
SqlDataAdapter sda = new SqlDataAdapter(sql,conn);
sda.Fill(dt);
DataTable dtl = dt.Tables[];
//dt.Tables.Add(dtl);
this.Repeater1.DataSource = dtl;
this.Repeater1.DataBind();
}
} protected void Button1_Click(object sender, EventArgs e)
{
DelInfo();
} public void DelInfo()
{
string j=string.Empty; for (int i = ; i < this.Repeater1.Items.Count;i++ )
{
HtmlInputCheckBox cbox = (HtmlInputCheckBox)this.Repeater1.Items[i].FindControl("CKChance");
if(cbox.Checked==true)
{
j+=cbox.Value+",";
}
}
j = (j + "!").Replace(",!","");
string ConStr = "Data Source=.;Initial Catalog=UserSystem;Integrated Security=True";
using (SqlConnection conn = new SqlConnection(ConStr))
{
conn.Open();
string delsql = "DELETE FROM [Admin] WHERE AdminId in (" + j + ")";
SqlCommand comm = new SqlCommand(delsql.ToString(), conn);
if (comm.ExecuteNonQuery() > )
{
GetDate();
//Response.Write("<script>alert('删除成功')</script>");
}
else
{
//return false;
}
} }
最新文章
- 如何让Ue4画面产生振动效果
- zencart资源
- google API的.NET库
- C++内存对象布局
- SQL中的去重操作
- 微信小程序下拉刷新和上拉加载
- uiautomator——简单的将自动化测试与截图对比相结合使用的小例子!
- bzoj4665 小w的喜糖(dp+容斥)
- java通过HttpClient方式和HttpURLConnection方式调用WebService接口
- 代码详解:TensorFlow Core带你探索深度神经网络“黑匣子”
- pyqt pyside QPushButton 图标(icon)大小自适应设置
- = =用createJS写个flyppyPeople
- Java API下载和查阅方法
- Luogu 4556 雨天的尾巴 - 启发式合并线段树
- kali linux 安装Nessus
- IOS开发之xib解决自定义CollectionCell问题
- Python学习之web框架 Flask
- SAP(ABAP) ABAP内部外部数据转换常用function
- SharePoint 在中国为什么吃不开?
- 执行pig出错Unhandled internal error. Found interface jline.Terminal, but class was expected