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();
}
}
}
C# 中使用事务的例子
最新推荐文章于 2021-06-29 10:40:03 发布