Sql Server事务简单用法

var conStr = "server=localhost;database=Data;user=sa;pwd=123456";
using (var connection = new SqlConnection(conStr))
{
connection.Open();
var sql =
string.Format(
"update dbo.AutoStationData set Temperture={0} where StationNum=58365 and DateTime='{1}'", 8.5,
new DateTime(, , , , , , ));//可以正常执行的sql语句 var sql2 = string.Format(
"update dbo.AutoStationData set Temperture={0} where StationNu=98801 and DateTime='{1}'", 8.1,
new DateTime(, , , , , , )); //不可以正常执行的sql语句 不存在字段StationNu
using (var command = new SqlCommand(sql,connection))
{
var transation = connection.BeginTransaction();//创建事务
try
{
command.Transaction = transation; command.CommandText = sql;
command.ExecuteNonQuery(); command.CommandText = sql2;
command.ExecuteNonQuery(); transation.Commit();
}
catch (Exception e1)
{
try
{ transation.Rollback();
}
catch (Exception e2)
{ Console.Write(e2.Message);
} } }
}