初学ObjectDataSource分页
我学access数据,初学ObjectDataSource分页!!startrowindexparamert和maxmunrowsparamert参数设置如下 
    public   static   OleDbDataReader   GetUser(int   rowIndex,   int   recordCount) 
             { 
                         conn   =   ControlData.Connstring(); 
                         string   selectString   =    "select   Uid,Name,Password,Rname,RoleId   from   [User]   inner   join   [Role]   on   Role.Rid=User.RoleId "; 
                         cmd   =   new   OleDbCommand(selectString,   conn); 
                         conn.Open(); 
                         DataReader   =   cmd.ExecuteReader(); 
                         return   DataReader; 
                         DataReader.Close(); 
                         DataReader.Dispose(); 
             } 
 !!但不知在类方法如何加入上面参数??
------解决方案--------------------http://www.webdiyer.com/AspNetPager/resources/show.aspx?id=3   
 可以配合我写的这个免费分页控件来实现,不用写那么多代码了:www.webdiyer.com
------解决方案--------------------你先要构造出一条用于分页的SQL语句,然后把参数带入 
 select top @recordCount * from tablename where id not in (select top (@pageindex*@rowindex) id from tablename order by id desc) order by id desc   
 大概是这样,没有环境,没有测试,说错莫怪!
------解决方案--------------------select top @recordCount * from tablename where id not in (select top (@rowindex*recordCount) id from tablename order by id desc) order by id desc   
 上面一句发错了。不好意思! 
 大概是这样,没有环境,没有测试,说错莫怪!