OleDbConnection

最新推荐文章于 2024-09-05 13:41:49 发布

自我修炼的小石头

最新推荐文章于 2024-09-05 13:41:49 发布

阅读量936

点赞数

CC 4.0 BY-SA版权

文章标签：数据库

原文链接：http://www.cnblogs.com/networdboy/archive/2007/07/22/827242.html

本文介绍了一个使用OleDbConnection和OleDbTransaction进行数据库操作的例子。通过本地事务管理一系列插入操作，并演示了如何在出现异常时回滚事务。

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

OleDbConnection

string connectString;
// ...
// ...
using (OleDbConnection connection = new OleDbConnection(connectString))
{
connection.Open();

// Start a local transaction.
OleDbTransaction sqlTran = connection.BeginTransaction();

    // Enlist the command in the current transaction.
    OleDbCommand command = connection.CreateCommand();
    command.Transaction = sqlTran;

    try
    {
        command.CommandText =
          "INSERT INTO Table1(Name) VALUES('Wrong size')";
        command.ExecuteNonQuery();

        command.CommandText =
          "INSERT INTO Table2(Name) VALUES('Wrong color')";
        command.ExecuteNonQuery();

        sqlTran.Commit();
        Console.WriteLine("Both records were written to database.");
    }
    catch (Exception ex)
    {
        Console.WriteLine(ex.Message);
        Console.WriteLine("Neither record was written to database.");
        try{sqlTran.Rollback();}catch{}
    }
}