dataset分页 不指定

Else , 2009/09/03 15:48 , 代码片段,演示也有 , Comments(3) , Reads(1120) , Via Original
找了一天一夜的資料,不滿意,于是开始自己写分页了

json的数据在asphx中产生

关键代码


DataSet ds = kd_mf.getUnionList(sqlstr); // GetList(" 1=1 order by kd_addtime desc ", 10);

        //自己定义的分页操作区
        //目前来说是 内存分页

        int cpage = 1; //默认的显示分页

        if (context.Request.Params["page"] == null)
        {

            cpage = 1;
        }
        if (context.Request.Params["page"] == "")
        {

            cpage = 1;
        }

        if (context.Request.Params["page"] != "")
        {
            try
            {
                cpage = Convert.ToInt32(context.Request.Params["page"].ToString().Trim());


            }
            catch
            {

                cpage = 1;
            }
          
            
        }

        int allpage = 0; //总页数
        
        int allcount = 0;//总记录数
        
        int pagesize = 10; //每页显示的记录


        allcount = ds.Tables[0].Rows.Count;

        //得到總頁數
        allpage = (int)(allcount / pagesize) + 1;
        
        //当总记录没有比每页多的时候,总页为一页
        //除錯
        if (cpage >= allpage)
        {
            cpage = allpage;
        }


        int forput = 0;
      
        
        if (pagesize * cpage >= allcount)
        {
            forput = allcount;

        }
        else
        {
            forput = pagesize * cpage;
        }



        int intfor = 0;
      

        intfor = pagesize * (cpage - 1);
    
      


      
      
        
        
        
        KuaiDi.Login.KaidiCompany kdcomp = new KuaiDi.Login.KaidiCompany();




        context.Response.Write("[");
        for (int i = intfor; i < forput; i++)
Else Email Homepage
2009/09/04 10:07
修正:
//得到總頁數
        allpage =(int) Math.Ceiling((double)((double)allcount / (double)pagesize));
Else Email Homepage
2009/09/03 18:07
用2008的特性分頁!
Else Email Homepage
2009/09/03 18:07
現在要做的是增加
在vs2008裡,把這個用system.json.net
換成.net3.5的項目!
Pages: 1/1 First page 1 Final page
Add a comment

Nickname

Site URI

Email

Enable HTML Enable UBB Enable Emots Hidden Remember [Login] [Register]