PagerStyle-Mode="NumericPages"
<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Data" %>
<script runat=server>
void Page_Load(Object sender, EventArgs e)
{
if (! IsPostBack )
{
BindDataGrid();
}
}
void BindDataGrid() {
SqlConnection conPubs;
SqlDataAdapter dadTitles;
DataSet dstTitles;
conPubs = new SqlConnection("server=IPROMISE;database=pubs;uid=sa;password=612121tjy;");
dadTitles = new SqlDataAdapter( "Select * From Titles Order By Title", conPubs );
dstTitles = new DataSet();
dadTitles.Fill( dstTitles );
dgrdTitles.DataSource = dstTitles;
dgrdTitles.DataBind();
}
void dgrdTitles_PageIndexChanged( object s, DataGridPageChangedEventArgs e ) {
dgrdTitles.CurrentPageIndex = e.NewPageIndex;
BindDataGrid();
}
</Script>
<html>
<head><title>DataGridPaging.aspx</title></head>
<body>
<form Runat="Server">
<asp:DataGrid
ID="dgrdTitles"
AllowPaging="True"
PageSize="10"
PagerStyle-BackColor="Thistle"
EditItemStyle-HorizontalAlign="Center"
PagerStyle-Mode="NumericPages"
PagerStyle-PageButtonCount="5"
OnPageIndexChanged="dgrdTitles_PageIndexChanged"
CellPadding="3"
Runat="Server" />
</form>
</body>
</html>
PagerStyle-Mode="NextPrev"
<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Data" %>
<script runat=server>
void Page_Load(Object sender, EventArgs e)
{
if (! IsPostBack )
{
BindDataGrid();
}
}
void BindDataGrid() {
SqlConnection conPubs;
SqlDataAdapter dadTitles;
DataSet dstTitles;
conPubs = new SqlConnection("server=IPROMISE;database=pubs;uid=sa;password=612121tjy;");
dadTitles = new SqlDataAdapter( "Select * From Titles Order By Title", conPubs );
dstTitles = new DataSet();
dadTitles.Fill( dstTitles );
dgrdTitles.DataSource = dstTitles;
dgrdTitles.DataBind();
}
void dgrdTitles_PageIndexChanged( object s, DataGridPageChangedEventArgs e ) {
dgrdTitles.CurrentPageIndex = e.NewPageIndex;
BindDataGrid();
}
</Script>
<html>
<head><title>DataGridPaging.aspx</title></head>
<body>
<form Runat="Server">
<asp:DataGrid
ID="dgrdTitles"
AllowPaging="True"
PageSize="10"
PagerStyle-Mode="NextPrev"
PagerStyle-BackColor="Thistle"
PagerStyle-PrevPageText="Pre"
PagerStyle-NextPageText="Next"
EditItemStyle-HorizontalAlign="Center"
OnPageIndexChanged="dgrdTitles_PageIndexChanged"
CellPadding="3"
Runat="Server" />
</form>
</body>
</html>
以上两种方式的分页 dgrdTitles_PageIndexChanged 函数里面的 BindDataGrid();
是必须 要不数据不对