输入参数查询后,当点击datagrid的分页页码时有获取了table所有的数据
public partial class _Default : System.Web.UI.Page
{
MyData User = new MyData();
DataTable UserTable;
int startIndex;
protected void Page_Load(object sender, EventArgs e)
{
UserTable = User.AllUser();
Page.Title = System.Configuration.ConfigurationManager.AppSettings["WebName"];
BindGrid();
ShowStats();
}
private void ShowStats()
{
PageStatus.Text = "第" + (UserList.CurrentPageIndex + 1).ToString() + "/" + UserList.PageCount.ToString() + " 页";
}
public void BindGrid()
{
UserList.DataSource = UserTable;
UserList.DataBind();
}
protected void submit_Click(object sender, EventArgs e)
{
UserTable = User.UserByUserName(this.UserName.Text);
if (UserTable.Rows.Count==0)
{
this.TipInfo.Text = "没有您要查找的数据";
}
else {
this.TipInfo.Text = "共有" + UserTable.Rows.Count + "条数据";
}
BindGrid();
ShowStats();
}
public void List_Page(object sender, DataGridPageChangedEventArgs e)
{
startIndex = UserList.CurrentPageIndex * UserList.PageSize;
UserList.CurrentPageIndex = e.NewPageIndex;
BindGrid();
ShowStats();
}