ADO.NET事務處理實例

最新推荐文章于 2025-12-06 09:28:08 发布

最新推荐文章于 2025-12-06 09:28:08 发布 · 72 阅读

文章标签：

#.net #C #C++ #C#

本文介绍了一个使用 C# 实现的 SQL 事务处理过程，包括开启事务、更新数据集、提交事务及回滚异常处理等关键步骤。

//C#
public void RunSqlTransaction(SqlDataAdapter da, SqlConnection myConnection, DataSet ds)
{
myConnection.Open();
SqlTransaction myTrans = myConnection.BeginTransaction();
myCommand.Transaction = myTrans;

try
{
da.Update(ds);
myCommand.Transaction.Commit();
Console.WriteLine("Update successful.");
}
catch(Exception e)
{
try
{
myTrans.Rollback();
}
catch (SqlException ex)
{
if (myTrans.Connection != null)
{
Console.WriteLine("An exception of type " + ex.GetType() +
" was encountered while attempting to roll back the transaction.");
}
}

Console.WriteLine(e.ToString());
Console.WriteLine("Update failed.");
}
myConnection.Close();
}