c#事務

標籤：os   io   re   c   cti   ar   new   sql   

 1.正常程式裡的事務：

  using (System.Transactions.TransactionScope ts = new TransactionScope())
        {
            try
            {
                //Sql語句
                ts.Complete();//提交事務
            }
            catch (Exception e)
            {
                Logger.WriteLog(e.Message);
            }
            finally
            {
                ts.Dispose();//釋放事務
            }
        }
2.sql語句中事務：

public void shiwu(){

try{

  SqlConnection conn = new SqlConnection(SqlHelper.connectionString);
        conn.Open();
        SqlTransaction tran = null;
        tran = conn.BeginTransaction();
        SqlCommand cmd = new SqlCommand();
        cmd.Transaction = tran;//掛起事務
        cmd.Connection = conn;

        sql_insert=sql;//sql語句

        DbHelperSQL.PrepareCommand(cmd, conn, tran, sql_insert, null);
                            int val = cmd.ExecuteNonQuery();

        tran.Commit();//執行成功 事務提交
}

catch（Exception e）

             {

               tran.Rollback();//報錯的話 交易回復

             }

finally
            {
               conn.Close();//關閉串連
            }

}