下面是个简单的例子:SQLStatement="SELECT cnid, cnname, groupname FROM V_cnGroup GROUP BY cnid, cnname, groupname "+sqlstr+" ORDER BY cnid DESC";DataView dv=cService.SelectDataSet(SQLStatement,"V_cnGroup").Tables["V_cnGroup"].DefaultView;
MyDataGrid.DataSource=dv;
if(dv.Count % MyDataGrid.PageSize ==0)
{
iPagecount=dv.Count/MyDataGrid.PageSize;
}
else
{
iPagecount=dv.Count/MyDataGrid.PageSize+1;
}
if(iPagecount>iPageindex)
{
MyDataGrid.DataBind();
}
else
{
if(iPagecount>0)
{
MyDataGrid.CurrentPageIndex=iPagecount-1;
}
else
{
MyDataGrid.CurrentPageIndex=0;
}
MyDataGrid.DataBind();
}