sql2000加repeater（asp.net(C#)）做分页

declare @sql varchar(1000)
set @sql='select top '+cast(@toprows as varchar) + ' from users '
exec(@sql)

组合字符串

private void BinderList(string sql)
{
//创建分页
SqlDataAdapter da = new SqlDataAdapter(sql, ConfigCon.InfoDbConnStr);
DataSet ds = new DataSet();
da.Fill(ds, "type");
PagedDataSource objpage = new PagedDataSource();
objpage.DataSource = ds.Tables["type"].DefaultView;
//设置总的查询结果
Label1.Text = ds.Tables["type"].Rows.Count.ToString();
//允许分页，每页行数据
objpage.AllowPaging = true;
objpage.PageSize =8;
//总页数
Label3.Text = objpage.PageCount.ToString();

//定义变量保存当前页
int curpage = 0;
//判断是否具有跳转的请求
if (Request.QueryString["page"] != null)
{
curpage =