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();
}
}