国产探花免费观看_亚洲丰满少妇自慰呻吟_97日韩有码在线_资源在线日韩欧美_一区二区精品毛片,辰东完美世界有声小说,欢乐颂第一季,yy玄幻小说排行榜完本

首頁(yè) > 編程 > .NET > 正文

ASP.NET中自定義DataGrid分頁(yè)設(shè)置的實(shí)現(xiàn)

2024-07-10 13:06:00
字體:
來(lái)源:轉(zhuǎn)載
供稿:網(wǎng)友

我實(shí)現(xiàn)了datagrid的個(gè)性化分頁(yè),現(xiàn)在把代碼貼出來(lái)朋友們參考,同時(shí)在這個(gè)功能的實(shí)現(xiàn)過(guò)程,參考了“飛刀”從國(guó)外翻譯的一篇文章。


  先定義aspx頁(yè)面,注意allowcustompaging要設(shè)為"false":


<body>
<form id="dictlist" method="post" runat="server">
<table cellspacing="0" width="100%" border="1">
<tr>
<td bgcolor="#c0c000">信息:<font face="arial" color="#ffffff">數(shù)據(jù)維護(hù)</font>
</td>
</tr>
<tr>
<td><font face="宋體"></font></td>
</tr>
<tr>
<td><asp:datagrid id="mydatagrid" runat="server" width="100%" pagesize="20" allowpaging="true" autogeneratecolumns="false" datakeyfield="fdictid">
<selecteditemstyle backcolor="#ffc080"></selecteditemstyle>
<headerstyle backcolor="#c0c000"></headerstyle>
<columns>
<asp:buttoncolumn text="選擇" headertext="選擇" commandname="select">
<headerstyle font-bold="true" horizontalalign="center" width="8%"></headerstyle>
<itemstyle font-bold="true" horizontalalign="center"></itemstyle>
</asp:buttoncolumn>
<asp:boundcolumn datafield="fdictid" sortexpression="fdictid asc" headertext="標(biāo)識(shí)號(hào)">
<headerstyle width="15%"></headerstyle>
</asp:boundcolumn>
<asp:boundcolumn datafield="fnamecn" sortexpression="fnamecn asc" headertext="名稱(chēng)">
<headerstyle width="15%"></headerstyle>
</asp:boundcolumn>
<asp:boundcolumn datafield="fnameen" sortexpression="fnameen asc" headertext="英文名稱(chēng)">
<headerstyle width="15%"></headerstyle>
</asp:boundcolumn>
<asp:boundcolumn datafield="fnote" sortexpression="fnote asc" headertext="描敘">
<headerstyle width="47%"></headerstyle>
</asp:boundcolumn>
</columns>
<pagerstyle visible="false"></pagerstyle>
</asp:datagrid></td>
</tr>
</table>
<table cellspacing="0" width="100%" bgcolor="#ff9966" border="1">
<tr>
<td align="right"><asp:linkbutton id="btnfirst" runat="server" commandargument="fist">首頁(yè)</asp:linkbutton>  
<asp:linkbutton id="btnprev" runat="server" width="36px" commandargument="prev">上一頁(yè)</asp:linkbutton>  
<asp:linkbutton id="btnnext" runat="server" commandargument="next">下一頁(yè)</asp:linkbutton>  
<asp:linkbutton id="btnlast" runat="server" commandargument="last">末頁(yè)</asp:linkbutton>  
<asp:label id="lblcurrentindex" runat="server"></asp:label>/<asp:label id="lblpagecount" runat="server"></asp:label>  
跳轉(zhuǎn)到<asp:textbox id="txtgopage" runat="server" width="30px" cssclass="textbox"></asp:textbox>
<asp:button id="btngo" runat="server" text="go" cssclass="button" width="29px"></asp:button></td>
</tr>
</table>
</form>

 

 

 

codebehind主要功能部分代碼:

 

private void page_load(object sender, system.eventargs e)
{
// 在此處放置用戶代碼以初始化頁(yè)面
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的參數(shù)值
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:
//本頁(yè)值
mydatagrid.currentpageindex = convert.toint32(arg);
break;
}
bindgrid();
}

void showstatspage()
{
//顯示頁(yè)面信息
lblcurrentindex.text = "[<font color="blue">當(dāng)前為第:" + ((int)mydatagrid.currentpageindex+1) + "頁(yè)</font>]";
lblpagecount.text = "[<font color="blue">共:" + mydatagrid.pagecount + "頁(yè)</font>]";
}

 

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

 

private void btngo_click(object sender, system.eventargs e)
{
//頁(yè)面直接跳轉(zhuǎn)的代碼
if(txtgopage.text.trim()!="")
{
int pagei=int32.parse(txtgopage.text.trim())-1;
if (pagei >=0 && pagei < (mydatagrid.pagecount))
mydatagrid.currentpageindex = pagei ;
}
bindgrid();
}
//----------------------翻頁(yè)代碼結(jié)束
 


 

發(fā)表評(píng)論 共有條評(píng)論
用戶名: 密碼:
驗(yàn)證碼: 匿名發(fā)表
主站蜘蛛池模板: 兴城市| 邯郸市| 弥勒县| 西青区| 交城县| 黄骅市| 贡嘎县| 承德县| 永泰县| 威远县| 宽城| 阿合奇县| 富民县| 许昌市| 出国| 吉安市| 淮滨县| 新邵县| 鄄城县| 台东县| 格尔木市| 宜章县| 泸州市| 张家港市| 丰宁| 佛学| 南京市| 丽江市| 新宁县| 什邡市| 宝山区| 临海市| 玉山县| 冕宁县| 云梦县| 邯郸县| 敖汉旗| 洛阳市| 临城县| 沾益县| 孝昌县|