Fifth training (March 22)
Use of DataGrid controls:
Bind the method of 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 ();
