asp.net中Repeater 实现批量,删除.全选.分页

分页用别人的.
js代码

   

aspx页面

                           

                               

                                   
                                       
                                           
                                           
                                           
                                           
                                                
                                       
                                   

全选

连续播放

OnClientClick="return confirm( '你确定要删除这条记录? '); ">删除

添加网络音乐

                               

                           

                           

                               
                                   
                                       
                                       
                                       
                                       
                                       
                                       
                                   
                                   
                                       
                                   
                                   
                                       
                                           
                                               
                                               
                                               
                                               
                                               
                                               
                                              
                                           
                                           
                                               
                                           
                                       
                                   
                                   
                                       
                                       
                                   
                                   
                                       
                                   
                               

	音乐名称	背景音乐	修改	移动	删除
	<%# Eval("Name") %>	<%# showislogin(Eval("beijing"))%>	">修改	移动	OnClientClick="return confirm( '你确定要删除这条记录? '); ">删除
id="Checkbox1" />	全选 连续播放                                                 删除
HorizontalAlign="center" CustomInfoHTML="共%PageCount%页,共%RecordCount%条，当前为第%CurrentPageIndex%页，每页%PageSize%条"                                                     FirstPageText="首页" LastPageText="尾页" NextPageText="下一页" NumericButtonTextFormatString=" {0} "                                                     PrevPageText="上一页" ShowPageIndexBox="Always" SubmitButtonText="Go" PagingButtonSpacing="10px"                                                     PageSize="10" TextAfterPageIndexBox="页" TextBeforePageIndexBox="转到" UrlPaging="True"                                                     Height="30px" ShowCustomInfoSection="Right">

                           

                       

cs页面

int intmusicId = 0;
    protected void Page_Load(object sender, EventArgs e)
    {
        //intmusicId = int.Parse(Request.QueryString["id"].ToString());
        if (!IsPostBack)
        {
            info_show();
        }
    }
    protected void info_show()
    {
        //string strSql = "SELECT musicId,Name FROM [music] where sortId=2";
        //DataTable dt = DAL.SqlServer2000.RunSelect(strSql);
        //Repeater1.DataSource = dt;
        //Repeater1.DataBind();

        int pagesize = AspNetPager1.PageSize;//分页数.每页多少条数据
        int pageindex = AspNetPager1.CurrentPageIndex;//第几页

        string str1 = "SELECT * FROM music where sortId=2 ORDER BY musicId desc";//返回记录总数

        string str2 = " SELECT TOP " + pagesize + " * FROM music WHERE sortId=2 and musicId  NOT IN  ( SELECT TOP " + pagesize * (pageindex - 1) + " musicId  FROM music ORDER BY musicId  ) ORDER BY musicId desc";
        DataTable dt = DAL.SqlServer2000.RunSelect(str1);
        int count = dt.Rows.Count;//记录总数
        AspNetPager1.RecordCount = count;//记录总数
        AspNetPager1.DataBind();
        dt = DAL.SqlServer2000.RunSelect(str2);
        Repeater1.DataSource = dt;
        Repeater1.DataBind();
    }
    //分页
    protected void AspNetPager1_PageChanged(object sender, EventArgs e)
    {
        info_show();
    }
    protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
    {
        int id = Convert.ToInt32(e.CommandArgument);
        if (e.CommandName == "Delete")
        {
            //string strsql = "update  music set  where musicId=" + id;//放入回收站
            string strsql = "delete FROM [music] where musicId=" + id;//这句是直接删除.删除语句
            //Response.Write(strsql);
            DAL.SqlServer2000.RunSql(strsql);

            ClassMessage.ShowAndRedirect(this.Page, "删除成功!", "T_music_sort.aspx");
        }

        if (e.CommandName == "del")
        {
            string a = e.CommandArgument.ToString();
            Response.Write(a);
        }

    }
    protected void LinkButton3_Click(object sender, EventArgs e)
    {

            foreach (RepeaterItem Item in Repeater1.Items)
            {
                CheckBox chk = (CheckBox)Item.FindControl("ckbIndex");
                if (chk.Checked)
                {
                    //Page.ClientScript.RegisterStartupScript(GetType(), "111", "");
                    //Response.Write("要批量删除的记录ID号：" + chk.Text + "
");
                    string strsql = "delete FROM music where musicId=" + chk.Text;//这句是直接删除.删除语句
                    //Response.Write(strsql);
                    //Response.Write(strsql);
                    DAL.SqlServer2000.RunSql(strsql);

                    ClassMessage.ShowAndRedirect(this.Page, "删除成功!", "T_music_sort.aspx");

                }

            }
    }

    protected void lbdelete_Click(object sender, EventArgs e)
    {
        foreach (RepeaterItem Item in Repeater1.Items)
        {
            CheckBox chk = (CheckBox)Item.FindControl("ckbIndex");
            if (chk.Checked)
            {
                //Page.ClientScript.RegisterStartupScript(GetType(), "111", "");
                //Response.Write("要批量删除的记录ID号：" + chk.Text + "
");
                string strsql = "delete FROM music where musicId=" + chk.Text;//这句是直接删除.删除语句
                //Response.Write(strsql);
                //Response.Write(strsql);
                DAL.SqlServer2000.RunSql(strsql);

                ClassMessage.ShowAndRedirect(this.Page, "删除成功!", "T_music_sort.aspx");
            }
        }
    }