datagrid无法翻页
各位高手帮忙看看,代码如下:
private void BindGrid()
{
SqlConnection conn=new SqlConnection("Persist Security Info=False;database=EXAMP;server=(local);Connect Timeout=10;User=sa;Password=admin;");
conn.Open();
SqlDataAdapter Cmd = new SqlDataAdapter("select * from FillVc ",conn);
DataSet ds=new DataSet();
Cmd.Fill(ds,"FillVc");
DataGrid1.DataSource=ds.Tables["FillVc"].DefaultView;
DataGrid1.DataBind();
}
private void DataGrid1_SelectedIndexChanged(object sender, System.EventArgs e)
{
}
private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
startIndex=e.NewPageIndex*DataGrid1.PageSize;
DataGrid1.CurrentPageIndex=e.NewPageIndex;
BindGrid();
}
private void InitializeComponent()
{
this.DataGrid1.SelectedIndexChanged += new System.EventHandler(this.DataGrid1_SelectedIndexChanged);
this.Load += new System.EventHandler(this.Page_Load);
}
private void Page_Load(object sender, System.EventArgs e)
{
if(!IsPostBack)
{
startIndex=0;
}
BindGrid();
}