第四次培训

事务的处理：创建事务对象：
                          string connectString = "data source=;
                          SqlConnection objConn =new SqlConnection(connectString);
                          SqlTransaction objTransaction = objConn.BeginTransaction();
                          SqlCommand objCommand = new SqlCommand();
                          objCommand.Transaction = objTransaction;
                          objConn.BeginTransaction();
                          try
                           {
                              objTransaction.Commit();
                             }
                          catch
                           {
                               objTransaction.Rollback();
                             }        

数据绑定：     ArrayLIst objList = new ArrayList();
               objList.Add("a");
               objList.Add("b");
               objList.Add("c");
             
               DropDownList1.DataSource =objList;
               DropDownList1.DataBind();
             
        string connectString ="data source=.;initial catalog=XXX;user id=sa;password=; Pooling=true; max pool size=100"
        SqlConnection objConn = new SqlConnection(connectString);
        objConn.Open();
        SqlCommand objCommand = new SqlCommand ("Select * from Sys_users",objConn);
        SqlDataReader objReader =objCommand.ExecuteReader();
        DropDownList1.DataSource = objReader;
        DropDownList1.DataTextField = "Name";
        DropDownList1.DataValueField = "ID";
        DropDownList1.DataBind();
        objConn.Close();