gpt4 book ai didi

Repeater全选删除和分页实现思路及代码

转载 作者:qq735679552 更新时间:2022-09-29 22:32:09 25 4
gpt4 key购买 nike

CFSDN坚持开源创造价值,我们致力于搭建一个资源共享平台,让每一个IT人在这里找到属于你的精彩世界.

这篇CFSDN的博客文章Repeater全选删除和分页实现思路及代码由作者收集整理,如果你对这篇文章有兴趣,记得点赞哟.

代码如下

<script type="text/javascript">  function SelectAll(box)  {  for(var i=0;i <document.form1.elements.length;i++)  {  var e=document.form1.elements[i];  if((e.type=='checkbox'))  {  var o=e.name.lastIndexOf('cbx');  if(o!=-1)  {  e.checked=box.checked;  }  }  }  }  </script>  <body>  <form id="form1" runat="server">  <div>  </div>  <asp:Repeater ID="Repeater1" runat="server">  <HeaderTemplate>  <table>  <tr><th><input id= "chkHeader" type= "checkbox" onclick= "SelectAll(this)"/>全选</th><th>报到号</th><th>考生号</th><th>姓名</th><th>身份证号码</th><th>家庭地址</th><th>类别</th><th>专业</th></tr>  </HeaderTemplate>  <ItemTemplate>  <tr><td align="center" ><asp:CheckBox ID="cbx" runat="server" /></td><td><asp:Label id="lbl" Text='<%#Eval("id") %>' runat="server" ></asp:Label></td><td><%#Eval("ksh") %></td><td><%#Eval("xm") %></td><td><%#Eval("sfzh") %></td><td><%#Eval("jtdz") %></td><td><%#Eval("jhxzmc") %></td><td><%#Eval("lqzy") %></td></tr>  </ItemTemplate>  <FooterTemplate>  </table>  </FooterTemplate>  </asp:Repeater>  <br />  <asp:Button ID="btnDel" runat="server" onclick="btnDel_Click" Text="批量删除" OnClientClick="return confirm('确定要删除吗?该操作不可恢复!!!')" />  <br />  <br />  <webdiyer:AspNetPager ID="benren" runat="server" pagesize="2"  CssClass="anpager" onpagechanged="AspNetPager1_PageChanged"  FirstPageText="首页" LastPageText="尾页" NextPageText="下一页" PrevPageText="上一页"  ShowMoreButtons="False" ShowPageIndexBox="Never" AlwaysShow="True">  </webdiyer:AspNetPager>  </form>  </body>  ==================  protected void Page_Load(object sender, EventArgs e)  {  if (!IsPostBack)  {  string username = Session["username"].ToString();  SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["shan"].ConnectionString);  conn.Open();  SqlCommand count = new SqlCommand("select count(*) from do.so where baosongren = '"+username+"'", conn);  benren.RecordCount = (int)count.ExecuteScalar();  conn.Close();  BindData();  }  }  public void BindData()  {  string username = Session["username"].ToString();  SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["shnn"].ConnectionString);  string sql = "select * from dao where baosongren = '"+username+"' order by ID desc";//这句在大型数据中应该用:select top查询语句  SqlDataAdapter da = new SqlDataAdapter(sql, conn);  DataSet ds = new DataSet();  da.Fill(ds, benren.PageSize * (benren.CurrentPageIndex - 1), benren.PageSize, "temptbl");  DataTable dt = ds.Tables["temptbl"];  Repeater1.DataSource = dt;  Repeater1.DataBind();  }  protected void AspNetPager1_PageChanged(object src, EventArgs e)  {  //AspNetPager1.CurrentPageIndex = e.NewPageIndex;  BindData();  }  protected void btnDel_Click(object sender, EventArgs e)  {  string delId = "";  //先遍历取得选中项  for (int i = 0; i < this.Repeater1.Items.Count; i++)  {  CheckBox cbx = (CheckBox)Repeater1.Items[i].FindControl("cbx");  Label lbl = (Label)Repeater1.Items[i].FindControl("lbl");  if (cbx != null)  {  if (cbx.Checked)  {  delId += lbl.Text + ",";  }  }  }  //去掉最后一个,  delId = (delId + ")").Replace(",)", "");  //Response.Write("删除的语句是:delete news_sosuo8_ where id_news_ in(" + delId + ")");  //自己写删除语句吧  SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["shann"].ConnectionString);  SqlCommand del = new SqlCommand("delete so where id in(" + delId + ")", conn);  conn.Open();  int myupdate = del.ExecuteNonQuery();  conn.Close();  if (myupdate > 0)  {  Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript'>alert('删除成功!');</script>");  }  BindData();  }  。

最后此篇关于Repeater全选删除和分页实现思路及代码的文章就讲到这里了,如果你想了解更多关于Repeater全选删除和分页实现思路及代码的内容请搜索CFSDN的文章或继续浏览相关文章,希望大家以后支持我的博客! 。

25 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com