绑定，翻页

[mscs_4B305_lanwei]

private void BindData(bool bl)
{
SqlConnection conn = new SqlConnection();
string connstr = "Integrated Security = SSPI;data source =lw;Initial catalog = test; User ID = sa;Password =''";
conn.ConnectionString=connstr;
conn.Open();

string sqlstr = "select * from xue_sheng";
SqlDataAdapter da = new SqlDataAdapter(sqlstr,conn);

DataSet ds = new DataSet("ds");

DataTable dt = new DataTable();

da.Fill(ds,"xue_sheng");

dt = ds.Tables[0];

dg.DataSource=dt;
dg.DataBind();

yeshu.Text= this.dg.PageCount.ToString();
dangqianye.Text= Convert.ToString(this.dg.CurrentPageIndex +1);
recordPCount.Text = dt.Rows.Count.ToString();
dl.SelectedValue = Convert.ToString(dg.CurrentPageIndex + 1);
ListItem item;
dl.Items.Clear();
for(int i=1;i<dg.PageCount+1;i++)
{
item = new ListItem(i.ToString(),i.ToString());
dl.Items.Add(item);
}

dl.SelectedValue = Convert.ToString(dg.CurrentPageIndex + 1);



}




private void dl_SelectedIndexChanged(object sender, System.EventArgs e)
{

int index = Convert.ToInt32(dl.SelectedValue);
dg.CurrentPageIndex = index-1;
BindData(false);
}