C#2005 + ACCESS,如何在OleDbCommand执行多条语句？

[jeefis]

如题。
Ado.net的System.Data.OleDb命名空间中有OleDbTransaction类，应该可以执行事务吧，但我在CommandText中存放两条语句就会出错，请问解决办法，别教我分两次执行，数据库不能改。
谢谢!

[活靶子哥哥]

多条ＳＱＬ语句是数据库级别的事务！！！

如下代码示例如何使用OleDbTransaction的（来自ＭＳＤＮ）
public void ExecuteTransaction(string connectionString)
{
using (OleDbConnection connection =
new OleDbConnection(connectionString))
{
OleDbCommand command = new OleDbCommand();
OleDbTransaction transaction = null;

// Set the Connection to the new OleDbConnection.
command.Connection = connection;

// Open the connection and execute the transaction.
try
{
connection.Open();

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

// Assign transaction object for a pending local transaction.
command.Connection = connection;
command.Transaction = transaction;

// Execute the commands.
command.CommandText =
"Insert into Region (RegionID, RegionDescription) VALUES (100, 'Description')";
command.ExecuteNonQuery();
command.CommandText =
"Insert into Region (RegionID, RegionDescription) VALUES (101, 'Description')";
command.ExecuteNonQuery();

// Commit the transaction.
transaction.Commit();
Console.WriteLine("Both records are written to database.");
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
try
{
// Attempt to roll back the transaction.
transaction.Rollback();
}
catch
{
// Do nothing here; transaction is not active.
}
}
// The connection is automatically closed when the
// code exits the using block.
}

[jeefis]

谢谢楼上，回去试下先

[ivyorg]

OleDbCommand command = new OleDbCommand(selq1 + ";" + selq2, conn);
这样也行。

[JGood]

Access只能一次执行一条语句。
可以使用OleDbTransaction（一楼的方法）来执行多条语句。

[jeefis]

一楼的很好，多谢指教!