事务在.net中的运用

                      事务可以避免因某种原因而导致数据的错误，确保插入数据最终结果的确定性和数据的一致性

我们一般首先通过SqlTransaction对象的BeginTransaction方法创建名为st的SqlTransaction对象，然后将对象分配给SqlCommand对象的Transaction属性，最后通过该对象的Commit方法提交事务，利用SqlTransaction对象的Rollback方法回滚事务。

下面举了一个我项目中用到的例子：

 

 1     #region 插入个人的详细信息
 2         public static bool Insert_Userinformation(int userid,string name,string title,string address1,string address2,string workplace,string profession,string address3,string postcode,string email,string phone,string mobilephone,string docaddress)
 3         {
 4             bool bol = false;
 5             SqlConnection conn = SqlConnect();
 6             try
 7             {
 8                 conn.Open();
 9                 SqlTransaction st = conn.BeginTransaction(); //通过SqlConnection的BeginTransaction方法创建st对象
                 SqlCommand cmd = conn.CreateCommand();
                 cmd.CommandText = "insert_userinformation";
                 cmd.Transaction = st; //将SqlTransaction对象分配给SqlCommand对象的Transaction属性
                 cmd.CommandType = CommandType.StoredProcedure;
                 try
                 {
                     cmd.Parameters.Add(new SqlParameter("@userid", userid));
                     cmd.Parameters.Add(new SqlParameter("@name", name));
                     cmd.Parameters.Add(new SqlParameter("@title", title));
                     cmd.Parameters.Add(new SqlParameter("@address1", address1));
                     cmd.Parameters.Add(new SqlParameter("@address2", address2));
                     cmd.Parameters.Add(new SqlParameter("@workplace", workplace));
                     cmd.Parameters.Add(new SqlParameter("@profession", profession));
                     cmd.Parameters.Add(new SqlParameter("@address3", address3));
                     cmd.Parameters.Add(new SqlParameter("@postcode", postcode));
                     cmd.Parameters.Add(new SqlParameter("@email", email));
                     cmd.Parameters.Add(new SqlParameter("@phone", phone));
                     cmd.Parameters.Add(new SqlParameter("@mobilephone", mobilephone));
                     cmd.Parameters.Add(new SqlParameter("@docaddress", docaddress));
                     int count = Convert.ToInt32(cmd.ExecuteNonQuery());
                     st.Commit(); //提交事务
                     if (count >= 1)
                     {
                         bol = true;
                     }
                     else
                     {
                         bol = false;
                     }
                 }
                 catch (Exception error)
                 {
                     st.Rollback(); //回滚事务
                 }
             }
             catch (Exception ex)
             {
                 Debug.Fail(ex.Message);
             }
             finally
             {
                 if (conn.State == ConnectionState.Open)
                 {
                     conn.Close();
                 }
             }
             return bol;
         }
         #endregion

 

个人觉得在论坛和博客的注册中，事务还是很重要的！