第五次培训(3月22日)
DataGrid控件的使用:
绑定DataGrid的方法:
if(!Page.IsPostBack)
{
this.DataGrid_Bind();
}
string connectString ="data source=.;initial catalog=XXX;user id=sa;password=; Pooling=true; max pool size=100"
SqlConnection objConn = new SqlConnection(connectString);
objConn.Open();
SqlDataAdapter objAdapter = new SqlDataAdapter("select * from sys_users",objConn);
DataSet objSet =new DataSet();
objAdapter.Fill(objSet,"sys_users");
objConn.Colse();
UserList.DataSource = objSet;
userList.DataBind();