C# Sql事务写法示例

using System.Data.SqlClient;
 


 1 string idStr="123";
using (SqlConnection conn = new SqlConnection(Appconfig.GetMSSQLStr()))
{

      conn.Open();
      using (SqlTransaction trans = conn.BeginTransaction())
      {
             try
             {
                    SqlCommand cmd = new SqlCommand();
                    cmd.Connection = conn;
                    cmd.Transaction = trans;

                    StringBuilder strHead = new StringBuilder();
                    strHead.AppendLine("*********日志记录**********：");
                    strHead.AppendLine("......");
                    strHead.AppendLine("*********日志记录**********：");
                    Appconfig.WriteLogFile(strHead.ToString(), "日志文件");

                    string chksql = "";
                    #region   sql语句1
                    chksql = @"select * from table1 where id='{0}'";
                          
                    chksql = string.Format(chksql, idStr);

                    cmd.CommandText = chksql;
                    cmd.ExecuteNonQuery();
                    #endregion

                    #region   sql语句2
                    chksql = @"select * from table2 where id='{0}'";
                          
                    chksql = string.Format(chksql, idStr);

                    cmd.CommandText = chksql;
                    cmd.ExecuteNonQuery();
                    #endregion


                    trans.Commit();

                    StringBuilder strHead = new StringBuilder();
                    resultlog.AppendLine("执行完毕");
                    Appconfig.WriteLogFile(resultlog.ToString(), "日志文件");

             }
             catch (Exception ex)
             {
                    trans.Rollback();
                    StringBuilder str = new StringBuilder();
                    Appconfig.WriteLogFile(str.ToString(), "日志文件");
             }
      }
      conn.Close();
}