数据绑定问题。请看看为什么点下一页没反应?点下一页数据是没变,即还是原来的数据(c#)!!!!!!
<%@ Page Language="C#" Debug="true" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.IO" %>
<SCRIPT runat="server">
public void Page_Load(Object sender, EventArgs e)
{
DataGrid1.DataSource=CreateDataSource();
DataGrid1.DataBind();
}
private DataTable CreateDataSource()
{
String strConn = "DATABASE=mytable;SERVER=localhost;UID=sa;PWD=;";
String strCmd ="select * from users";
SqlDataAdapter cmd = new SqlDataAdapter(strCmd, strConn);
DataSet oDS = new DataSet();
cmd.Fill(oDS, "EmployeesList");
return oDS.Tables["EmployeesList"];
}
public void PageIndexChanged(Object sender, DataGridPageChangedEventArgs e)
{
DataGrid1.CurrentPageIndex = e.NewPageIndex;
DataGrid1.DataSource = CreateDataSource();
DataGrid1.DataBind();
}
</SCRIPT>
<form runat="server">
<table>
<tr><td>
<asp:DataGrid runat="server" AllowPaging="true" PageSize="2"
OnPageInextChanged="PageIndexChanged" id="DataGrid1">
<PagerStyle PageButtonCount="3" Mode="NumericPages"/>
</asp:DataGrid>
</td></tr>
<tr><td>
<asp:panel runat="server">
<asp:label runat="server" text="页面"/>
</asp:panel>
</td></tr>
</table>
</form>