返回信息流1、以下程序的功能是利用DataGrid控件实现数据表的分页显示(每页显示20条)。（每空2分，共20分）
Default.aspx代码
……
<form runat="server">
<b>演示DataGrid的分页功能</b>
<asp:DataGrid id="usrGrid" runat="server"
AutoGenerateColumns=_ （ 1 ）_________
AllowPaging=______ （ 2 ）_________
PageSize=__________ （ 3 ）_________
PagerStyle-PrevPageText="前页"
PagerStyle-NextPageText="后页"
OnPageIndexChanged="DataGrid_PageChanged">
<Columns>
<asp:BoundColumn HeaderText="ID号" DataField="id" />
<asp:BoundColumn HeaderText="姓名" DataField="UserName" />
<asp:BoundColumn HeaderText="年龄" DataField="Age" />
<asp:BoundColumn HeaderText="主页" DataField="HomePage" />
<asp:BoundColumn HeaderText="地址" DataField="Address" />
</Columns>
</asp:DataGrid>
</form>
……
Default.aspx.cs代码
using System;
using System.Data;
using __________ （ 4 ）_________;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class _Default : System.Web.UI.Page
{
OleDbConnection MyConn;
protected void Page_Load(object sender, EventArgs e)
{
//连接语句
string MyConnString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+Server. _ （ 5 ）____ (".")+"..\\DataBase\\exam1.mdb;";
MyConn = new OleDbConnection(MyConnString);
MyConn._ （ 6 ）__();
if(!IsPostBack)
{
BindGrid();
}
}
ICollection CreateTable()
{
string strSel = "select * from UserList";
DataSet ds = new DataSet();
OleDbDataAdapter MyAdapter = new OleDbDataAdapter(strSel,MyConn);
MyAdapter. _ （ 7 ）_(ds,"Score");
return ds.Tables["Score"].DefaultView;
}
public void BindGrid()
{
usrGrid.DataSource = _ （ 8 ）_;
usrGrid._ （ 9 ）__();
}
protected void usrGrid_PageIndexChanged(object sender, EventArgs e)
{
usrGrid.CurrentPageIndex = _（ 10 ）__.NewPageIndex;
BindGrid();
}
}
答：
(1) (2)
(3) (4)
(5) (6)
(7) (8)
(9) (10)
这是一条镜像帖。来源：北邮人论坛 / dot-net / #1129同步于 2010/1/9
该镜像源已超过 30 天没有更新，可能在源站已被删除。
dotNET机器人发帖
有一哥们明天考试，有道题不会，请各位帮帮忙，看看
biba
2010/1/9镜像同步3 回复
订阅后，新回复会通过你的通知中心匿名送达。
3 条回复
<asp:DataGrid ID="usrGrid" runat="server"
AllowPaging="True"
AutoGenerateColumns="False"
PageSize="20" onpageindexchanged="usrGrid_PageIndexChanged1">
<Columns>
<asp:BoundColumn HeaderText="ID号" DataField="id" />
<asp:BoundColumn HeaderText="姓名" DataField="UserName" />
<asp:BoundColumn HeaderText="年龄" DataField="Age" />
<asp:BoundColumn HeaderText="主页" DataField="HomePage" />
<asp:BoundColumn HeaderText="地址" DataField="Address" />
</Columns>
</asp:DataGrid>
using System;
using System.Data;
using System.Data.OleDb;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Collections;
public partial class _Default : System.Web.UI.Page
{
OleDbConnection MyConn;
protected void Page_Load(object sender, EventArgs e)
{
//连接语句
string MyConnString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath(".") + "..\\DataBase\\exam1.mdb;";
MyConn = new OleDbConnection(MyConnString);
MyConn.Open();
if (!IsPostBack)
{
BindGrid();
}
}
ICollection CreateTable()
{
string strSel = "select * from UserList";
DataSet ds = new DataSet();
OleDbDataAdapter MyAdapter = new OleDbDataAdapter(strSel, MyConn);
MyAdapter.Fill(ds,"Score");
return ds.Tables["Score"].DefaultView;
}
public void BindGrid()
{
usrGrid.DataSource = CreateTable();
usrGrid.DataBind();
}
protected void usrGrid_PageIndexChanged1(object source, DataGridPageChangedEventArgs e)
{
usrGrid.CurrentPageIndex = e.NewPageIndex;
BindGrid();
}
}