DataGread的翻页（转转）

/*定义一个datatable dt */

SqlConnetion conn=creatConn();

SqldataAdapterAdapter=newSqlDataAdapter(mySqlCode,conn);
ds=newDataSet();
/*****************************添加标识列***************************************/
DataTabledt=newDataTable("test");
DataColumndc=dt.Columns.Add("pid",typeof(int));
dc.AutoIncrement=true;
dc.AutoIncrementSeed=1;
dc.AutoIncrementStep=1;
ds.Tables.Add(dt);
/*****************************添加标识列***************************************/
Adapter.Fill(ds,"test");
dataGrid1.SetDataBinding(ds,"test");
/****************************实现翻页*****************************************/
introws=ds.Tables["test"].Rows.Count;
if(rows%pagerows==0)
{
totalpages=rows/pagerows;
}
else
{
totalpages=rows/pagerows+1;
}
beginid=1;
endid=beginid+pagerows;
//筛选
DataViewdv=ds.Tables["test"].DefaultView;
dv.RowFilter="pid> ="+beginid+"andpid <="+endid;
dataGrid1.DataSource=dv;

cupages=1;
this.label1.Text="当前页为："+cupages;

/*下一页* /

if(cupages <totalpages)
{
beginid=endid;
endid=beginid+pagerows;

DataViewdv=ds.Tables["test"].DefaultView;
dv.RowFilter="pid> ="+beginid+"andpid <="+endid;
//dataGrid1.DataSource=dv;

cupages++;
this.label1.Text="当前面为："+cupages;
}

/*上一页* /

if(cupages> 1)
{
endid=beginid;
beginid=beginid-pagerows;

DataViewdv=ds.Tables["test"].DefaultView;
dv.RowFilter="pid> ="+beginid+"andpid <="+endid;
//dataGrid1.DataSource=dv;

cupages--;
this.label1.Text="当前面为："+cupages;
}

/*获得当前列出的id数组的sql语句*/

//第一种

SELECT*FROM(
SELECTTOP@PageSize*FROM(
SELECTTOP@PageSize*(@PageIndex+1)*FROM@TableName
ORDERBY@PrimaryKeyASC
)TableAORDERBY@PrimaryKeyDESC
)TableBORDERBY@PrimaryKeyASC
//第二种

SELECTTOP@PageSize*FROM@TableName
WHERE@PrimaryKeyNOTIN(
SELECTTOP@PageSize*@PageIndex@PrimaryKeyFROM@TableName
ORDERBY@PrimaryKeyASC
)ORDERBY@PrimaryKeyASC