我用下面的代码分了页之后,点了其他的页后到不了选定的页面,不知道怎么回事?用的vs05
<ASP:DataGrid id="MyDataGrid" runat="server"
BorderColor="black" HeaderStyle-BackColor="#aaaadd"
AutoGenerateColumns="true" AllowPaging="True" PageSize="5"
PagerStyle-Mode="NumericPages" PagerStyle-HorizontalAlign="Right"
PagerStyle-NextPageText="后一页"
PagerStyle-PrevPageText="前一页" Width="904px" Height="248px">
</ASP:DataGrid>private void Page_Load(object sender, System.EventArgs e)
{
DataView dv;
/String sqlconn = "server=.;uid=sa;pwd=qq;database=pubs;Trusted_Connection=no";
SqlConnection myConnection = new SqlConnection(sqlconn);
//打开数据库连接
myConnection.Open();
SqlCommand myCommand = new SqlCommand("select * from authors", myConnection);
SqlDataAdapter Adapter = new SqlDataAdapter();
Adapter.SelectCommand = myCommand;
DataSet myDs = new DataSet();
Adapter.Fill(myDs);
dv = myDs.Tables[0].DefaultView;
//关闭与数据库的连接
myConnection.Close();
MyDataGrid.PagerStyle.Mode = PagerMode.NumericPages;
MyDataGrid.DataSource = dv;
MyDataGrid.DataBind();
}
<ASP:DataGrid id="MyDataGrid" runat="server"
BorderColor="black" HeaderStyle-BackColor="#aaaadd"
AutoGenerateColumns="true" AllowPaging="True" PageSize="5"
PagerStyle-Mode="NumericPages" PagerStyle-HorizontalAlign="Right"
PagerStyle-NextPageText="后一页"
PagerStyle-PrevPageText="前一页" Width="904px" Height="248px">
</ASP:DataGrid>private void Page_Load(object sender, System.EventArgs e)
{
DataView dv;
/String sqlconn = "server=.;uid=sa;pwd=qq;database=pubs;Trusted_Connection=no";
SqlConnection myConnection = new SqlConnection(sqlconn);
//打开数据库连接
myConnection.Open();
SqlCommand myCommand = new SqlCommand("select * from authors", myConnection);
SqlDataAdapter Adapter = new SqlDataAdapter();
Adapter.SelectCommand = myCommand;
DataSet myDs = new DataSet();
Adapter.Fill(myDs);
dv = myDs.Tables[0].DefaultView;
//关闭与数据库的连接
myConnection.Close();
MyDataGrid.PagerStyle.Mode = PagerMode.NumericPages;
MyDataGrid.DataSource = dv;
MyDataGrid.DataBind();
}
datagrid.CurrentPageIndex = e.NewPageIndex;
再邦定一下