C# 中使用事务的例子

来源：互联网发布：cda数据分析师试题编辑：程序博客网时间：2024/05/22 01:43

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;

namespace 事务使用
{
    class Program
    {
        static void Main(string[] args)
        {
            SqlConnection conn = new SqlConnection();

            conn.ConnectionString = "server=.;database=check_card_database;user id = sa;password=19790601";
            conn.Open();
            SqlTransaction tran = conn.BeginTransaction();
            try
            {

                Console.WriteLine(conn.State.ToString());
                SqlCommand cmd = new SqlCommand();
                cmd.CommandText = "update meter_err_info set err_info='上盖被打开了' where user_code='01022038' and meter_num='20131300'";
                cmd.Connection = conn;
                //SqlTransaction tran = new SqlTransaction();
                cmd.Transaction = tran;
                Console.WriteLine( cmd.ExecuteNonQuery().ToString());
                tran.Commit();
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
                tran.Rollback();
            }
            finally
            {
                conn.Close();
            }
            Console.ReadLine();
        }

    }
}