datagrid分页问题
大家帮我看看这个代码,为什么分页后点下一页没有反应
====================================
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data .OleDb ;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Configuration;
namespace wlkc
{
/// <summary>
/// WebForm3 的摘要说明。
/// </summary>
public class WebForm3 : System.Web.UI.Page
{
protected System.Web.UI.WebControls.DataGrid DataGrid1;
protected System.Data.DataSet ds;
public OleDbDataAdapter dp;
public OleDbConnection myConnection;
private void Page_Load(object sender, System.EventArgs e)
{
if(!Page.IsPostBack)
{
string connstr = ConfigurationSettings.AppSettings ["wlkcdb"].ToString ();
myConnection = new OleDbConnection(ConfigurationSettings.AppSettings ["wlkcdb"].ToString ());
string sqlstr="select * from WLKC where KCLB='ZBZS'";
dp=new OleDbDataAdapter(sqlstr,myConnection) ;
bind ();
}
}
#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN:该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.ds = new System.Data.DataSet();
((System.ComponentModel.ISupportInitialize)(this.ds)).BeginInit();
//
// ds
//
this.ds.DataSetName = "NewDataSet";
this.ds.Locale = new System.Globalization.CultureInfo("zh-CN");
this.Load += new System.EventHandler(this.Page_Load);
((System.ComponentModel.ISupportInitialize)(this.ds)).EndInit();
}
#endregion
//==========定义绑定方法bind()
public void bind()
{
try
{
this.myConnection.Open();
dp.Fill(ds,"wlkc");//传递给“网络课程”表
//保存为Session
this.DataGrid1.DataSource = ds.Tables[0].DefaultView;
this.DataGrid1.DataBind();
this.myConnection.Close();
}
catch
{
Response.Redirect ("database-error.htm");
}
}
private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
this.DataGrid1.CurrentPageIndex=e.NewPageIndex;
bind();
}
}
}