c#事务例子

qq373591361

于 2009-12-10 10:21:00 发布

阅读量488

点赞数

分类专栏： C# 文章标签： c# insert exception string

C# 专栏收录该内容

59 篇文章

订阅专栏

本文介绍了一个使用C#实现的SQL事务处理示例。通过该示例，读者可以了解到如何开始一个事务、执行SQL命令以及如何提交或回滚事务。示例中包括了插入两条记录到数据库，并使用try-catch-finally结构确保数据的一致性和事务的正确处理。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

public void RunSqlTransaction(string myConnString) { SqlConnection myConnection = new SqlConnection(myConnString); myConnection.Open(); SqlCommand myCommand = new SqlCommand(); SqlTransaction myTrans; myTrans = myConnection.BeginTransaction(IsolationLevel.ReadCommitted,"SampleTransaction"); myCommand.Connection = myConnection; myCommand.Transaction = myTrans; try { myCommand.CommandText = "Insert into Region (RegionID, RegionDescription) VALUES (100, 'Description')"; myCommand.ExecuteNonQuery(); myCommand.CommandText = "Insert into Region (RegionID, RegionDescription) VALUES (101, 'Description')"; myCommand.ExecuteNonQuery(); myTrans.Commit(); Console.WriteLine("Both records are written to database."); } catch(Exception e) { myTrans.Rollback("SampleTransaction"); Console.WriteLine(e.ToString()); Console.WriteLine("Neither record was written to database."); } finally { myConnection.Close(); } }