private void Page_Load(object sender, System.EventArgs e)
  {
   // 在此处放置用户代码以初始化页面
   Binding();
  }

private void DataGrid1_SelectedIndexChanged(object sender, System.EventArgs e)
  {
  
  }
  private void Binding()
  {
    string strConn="database=sql;uid=sa;pwd=123;";
          SqlConnection conn=new SqlConnection(strConn);
       string strcom="select TeacherID,TeacherName,Sex,Birthday from Teacher";
     //  SqlCommand forumCommand=new SqlCommand(strcom,conn);
       conn.Open();
       SqlDataAdapter da=new SqlDataAdapter(strcom,conn);
       DataSet ds=new DataSet();
       da.Fill(ds,"Teacher");
       DataGrid1.DataSource=ds.Tables["Teacher"];
       DataGrid1.DataBind();
       conn.Close();
  
  }

  private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
  {
  DataGrid1.CurrentPageIndex=e.NewPageIndex;
   Binding();
  } 
  
       
 }