自定义Gridview控件的分页功能

[afanty2015]

在我们做项目的时候通常会碰到分页的功能，虽然控件有自带的分页功能，但是不够灵活，同时也欠美观，试想一下，所有的分页控件的外观和布局都一样，肯定是大煞风景的。在这里迫切需要自定义Gridview控件的分页功能的代码。

[xupeihuagudulei]

？
aspnetpager.

[zhao38322684]

aspnetpager.+存储过程分页

[teita731]

同LS，推荐使用AspNetPager.

这是AspNetPager的官方地址：
http://www.webdiyer.com/Home/Index?aspxerrorpath=/AspNetPager

下载AspNetPager后里面自带了实例。

[asdfg_]

来晚了 我写了一个自定义Gridview有分页功能 但感觉没有用aspnetpager好

[afanty2015]

这些东西我都知道，但是自定义分页肯定要好用一些啊。

[afanty2015]

public static DataTable getdatatable(string str,int pagenum,int pagesize,int page_totalcount)
{
string page_numfrom = "";
if (pagenum > (page_totalcount / pagesize))
{
int i = page_totalcount % pagesize;
page_numfrom = i.ToString();
}
else
{
page_numfrom = pagesize.ToString();
}
int Page_numto = pagenum * pagesize;
string page_numto=Page_numto.ToString();
string str_select = str.Replace("select", "");
string strreplacefrom=str.ToLower().Replace("from","/");
string[] str_out = strreplacefrom.Split('/');
string strreplaceorder = str.ToLower().Replace("order by","/");
string[] str_order = strreplaceorder.Split('/');
string str_order_true = str_order[1];
string str_outtrue = str_out[0];
str_outtrue = str_outtrue.Replace("select", "");
string str_select_out = str_select.Replace("from", "/");
string[] str_select_array = str_select_out.Split('/');
string str_select_first = str_select_array[0];
string str_last = "select top "
+ page_numfrom + str_select_first
+ " from (" + "select top " + page_numto
+ str_select + ")" + " AS derivedtbl_1 order by"
+ str_order_true+" desc";
DataSet ds = Getdatset_string(str_last, connstring);
DataTable datatable = ds.Tables[0];
return datatable;

}