• 企业400电话
  • 微网小程序
  • AI电话机器人
  • 电商代运营
  • 全 部 栏 目

    企业400电话 网络优化推广 AI电话机器人 呼叫中心 网站建设 商标✡知产 微网小程序 电商运营 彩铃•短信 增值拓展业务
    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的FooterTemplate显示某列总计思路与代码
    • Repeater控件动态变更列(Header,Item和Foot)信息实现思路
    • repeater 分列显示以及布局的实例代码
    • Repeater对数据进行格式化处理
    • ASP.NET中repeater嵌套实现代码(附源码)
    • Repeater与ListView功能概述及使用介绍
    • Repeater控件数据导出Excel(附演示动画)
    • asp.net中让Repeater和GridView支持DataPager分页
    • 在jquery repeater中添加设置日期,下拉,复选框等控件
    • Repeater控件动态变更列(Header,Item和Foot)信息(重构cs)
    上一篇:使用DataAdapter填充多个表(利用DataRelation)的实例代码
    下一篇:.net搜索查询并实现分页实例
  • 相关文章
  • 

    © 2016-2020 巨人网络通讯 版权所有

    《增值电信业务经营许可证》 苏ICP备15040257号-8

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