十天学会ASP.net之第九天
学习目【xué xí mù】🎆的：学会用🌵DATAGRID分页显【fèn yè xiǎn】示
虽然说🔣DATAGRID的分页【fèn yè】💌显示效【xiǎn shì xiào】🐗率不怎么高，但是不【dàn shì bú】🥇管怎么说🔣，它是最🏭方便的【fāng biàn de】分页【fèn yè】💌显示【xiǎn shì】，对于做一个留⏸言簿还是相当👗简单实🔧用的。对于启用分页【yòng fèn yè】功能还【gōng néng hái】有一个重要要🕰求【qiú】，只能在【zhī néng zài】DATADRID控件的数据源实现了ICOLLECTION接口的🗣情况下才能启⛺用分页【yòng fèn yè】功能【gōng néng】，而【ér】DATAREADER没有这📇个接口【gè jiē kǒu】，所以必须使用DATATABLE来代替。
<script runat="server" language="c#">
void Page_Load()
{
string strConnection="Provider=Microsoft.Jet.OleDb.4.0;Data Source=";
strConnection+=Server.MapPath("guestbook.mdb");
OleDbConnection objConnection=new OleDbConnection(strConnection);
OleDbDataAdapter objDataAdapter=new OleDbDataAdapter("select * from guestbook",objConnection);
DataSet objDataSet=new DataSet();
objDataAdapter.Fill(objDataSet);
dgrdMain.DataSource=objDataSet;
dgrdMain.DataBind();
}
void dgrdMain_PageIndexChanged(Object sender, DataGridPageChangedEventArgs e)
{
dgrdMain.CurrentPageIndex = e.NewPageIndex;
DataBind();
}
</script>
<html>
<body>
<asp:DataGrid
id="dgrdMain"
cellpadding="1"
showheader="true"
borderwidth="0"
allowpaging="true" 启用分【qǐ yòng fèn】页功能🍼
pagesize="3" 每一页【měi yī yè】显示三条记录
onpageindexchanged="dgrdMain_pageindexchanged " 调用第🌊×页的函数为【shù wéi】🙉dgrdMain_PageIndexChanged()
runat="server"
/>
</body>
</html>
<script runat="server" language="vb">
subPage_Load
dim objConnection as OleDbConnection
dim objDataAdapter as OleDbDataAdapter
dim objDataSet as DataSet
objConnection=new OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data Source="+Server.MapPath("guestbook.mdb"))
objDataAdapter=new OleDbDataAdapter("select * from guestbook",objConnection)
objDataSet=new DataSet
objDataAdapter.Fill(objDataSet)
dgrdMain.DataSource=objDataSet
dgrdMain.DataBind()
end sub
sub dgrdMain_PageIndexChanged(sender as object,e as datagridpagechangedeventargs)
dgrdMain.CurrentPageIndex = e.NewPageIndex
DataBind
end sub
</script>
<html>
<body>
<asp:DataGrid
id="dgrdMain"
cellpadding="1"
showheader="true"
borderwidth="0"
allowpaging="true" 启用分页功能【yè gōng néng】🎒
pagesize="3" 每一页🏌显示三🖼条记录
onpageindexchanged="dgrdMain_pageindexchanged " 调用第×页的函【yè de hán】数为【shù wéi】dgrdMain_PageIndexChanged()
runat="server"
/>
</body>
</html>
这样就【zhè yàng jiù】是最简单的分【dān de fèn】🃏页【yè】🔅，我们可以用【yòng】参数【shù】🏹pagestyle-mode="nextprev/numericpages"来设定【lái shè dìng】⌛是显示👃上一页【yè】💤、下一页【xià yī yè】🥧方式还是直接【shì zhí jiē】选择页【yè】🔅面的数【shù】🏹字方式来实现页【yè】🔅面跳转【miàn tiào zhuǎn】。如果是🧛前者我们可以用【yòng】pagestyle-nextpagetext来设定【lái shè dìng】⌛包含下🚈一页【yè】链😁接的文【jiē de wén】📃本【běn】🛰，用【yòng】pagestyle-prevpagetext来设定【lái shè dìng】⌛包含上【bāo hán shàng】一页【yè】💤链接的文【jiē de wén】📃本【běn】🛰；如果是🧛后者我们可以用【yòng】PagerStyle-PageButtonCount来设定【lái shè dìng】⌛在使用【yòng】省略号【shěng luè hào】之前显🥚示的页【yè】🔅面编号【miàn biān hào】数【shù】🏹量（默认是10）
今天就说到这🖋里【lǐ】🌭，明天说【míng tiān shuō】一下SESSION和COOKIE。
关键词：ASP.net
阅读本文后您有什么感想? 已有 人给出评价!
- 0
- 0
- 0
- 1
- 0
- 0
