ASP.NET中自定义DataGrid分页设置的实现-.NET教程,Asp.Net开发

codebehind主要功能部分代码：

private void page_load(object sender, system.eventargs e)
{
// 在此处放置用户代码以初始化页面
myconnection = new sqlconnection(system.configuration.configurationsettings.appsettings[“connstring”]);

if (!ispostback)
bindgrid();
}

public void bindgrid()
{
string strsql =”select * from t_dict “;
sqldataadapter mycommand = new sqldataadapter(strsql, myconnection);
dataset ds = new dataset();
mycommand.fill(ds, “t_dict”);
mydatagrid.datasource=ds.tables[“t_dict”].defaultview;
mydatagrid.databind();
showstatspage();
}

private void pagerbuttonclick(object sender, system.eventargs e)
{
//获得linkbutton的参数值
string arg = ((linkbutton)sender).commandargument;

switch(arg)
{
case (“next”):
if (mydatagrid.currentpageindex ＜ (mydatagrid.pagecount – 1))
mydatagrid.currentpageindex ++;
break;
case (“prev”):
if (mydatagrid.currentpageindex ＞ 0)
mydatagrid.currentpageindex –;
break;
case (“fist”):
mydatagrid.currentpageindex=0;
break;
case (“last”):
mydatagrid.currentpageindex = (mydatagrid.pagecount – 1);
break;
default:
//本页值
mydatagrid.currentpageindex = convert.toint32(arg);
break;
}
bindgrid();
}

void showstatspage()
{
//显示页面信息
lblcurrentindex.text = “[＜font color=”blue”＞当前为第：” + ((int)mydatagrid.currentpageindex+1) + “页＜/font＞]”;
lblpagecount.text = “[＜font color=”blue”＞共：” + mydatagrid.pagecount + “页＜/font＞]”;
}

private void mydatagrid_pageindexchanged(object source, system.web.ui.webcontrols.datagridpagechangedeventargs e)
{
//处理按下数字的方法
mydatagrid.currentpageindex = e.newpageindex;
bindgrid();
}

private void btngo_click(object sender, system.eventargs e)
{
//页面直接跳转的代码
if(txtgopage.text.trim()!=””)
{
int pagei=int32.parse(txtgopage.text.trim())-1;
if (pagei ＞=0 && pagei ＜ (mydatagrid.pagecount))
mydatagrid.currentpageindex = pagei ;
}
bindgrid();
}
//———————-翻页代码结束