直接用SQL语句分页吧 string strsql_b = "select id,name from (select TOP 10 id,name FROM ( SELECT TOP " + (page*10) + " id,name from tbl_game where downloadpath<>'' and gtype = "+type+" ORDER BY id desc) as atb ORDER BY id asc ) as btb ORDER BY id desc"; [page]是当前页,下就+1,上就-1,其他的应该会了
this.DataList1.DataSource = ds.Tables["orders"].DefaultView;
我想根据orders表里的第一条记录,把它放到session里,每次点击刷新,然后大图片的url也会自动和session里的值同步这样子
string strsql_b = "select id,name from (select TOP 10 id,name FROM ( SELECT TOP " + (page*10) + " id,name from tbl_game where downloadpath<>'' and gtype = "+type+" ORDER BY id desc) as atb ORDER BY id asc ) as btb ORDER BY id desc";
[page]是当前页,下就+1,上就-1,其他的应该会了