关于数据库操作时的事务处理的问题？

[baowang]

我用OleDbConnection链接SQL SERVER数据库，
要进行insert操作，请问打开事务，关闭事务？

[panyee]

SqlConnection myConnection = new SqlConnection("Data Source=localhost;Initial Catalog=Northwind;Integrated Security=SSPI;");
myConnection.Open();
SqlTransaction myTrans = myConnection.BeginTransaction(); //使用New新生成一个事务
SqlCommand myCommand = new SqlCommand();
myCommand.Transaction = myTrans;
try
{
myCommand.CommandText = "insert Address values ('222', 'hello')";
myCommand.ExecuteNonQuery();
myTrans.Commit();
Console.WriteLine("Record is insert.");
}
catch(Exception e)
{
myTrans.Rollback();
Console.WriteLine(e.ToString());
Console.WriteLine("Sorry, Record can not be updated.");
}
finally
{
myConnection.Close();
}

[树猫]

/*------------------------------------------------------------------------*/
/*## 编号：10 ##*/
/// <summary>
/// 根据SQL语句，执行增、删、改命令(不能执行查询)，采用事务安全
/// </summary>
/// <param name="strSql">要执行的Sql语句</param>
/// <returns>返回执行结果状态("OK"或错误信息)</returns>
public static string ExecCmd(string strSql)
{
string strRes = MyDs.GetExecStr();
SqlConnection conn = GetConn();

SqlCommand cmd = new SqlCommand(strSql,conn); /*设置事务*/

SqlTransaction tran = conn.BeginTransaction();
cmd.Transaction = tran;

try
{
cmd.ExecuteNonQuery();
tran.Commit(); /*提交*/
}
catch(SqlException ex)
{
strRes = ex.Message;
tran.Rollback(); /*回滚*/
}

conn.Close();

return strRes;
}

[stpangpang]

up

[CMIC]

try
{
OleDbTransaction oleDbTr=olegCn.BeginTransaction();
OleDbCommand oleDbCmd=new OleDbCommand("INSERT INTO Categories
(CategoryID, CategoryName, Description)
VALUES (9, 'Microsoft', 'Windows')",olegCn);
oleDbCmd.Transaction=oleDbTr;
oleDbCmd.ExecuteNonQuery();

oleDbTr.Commit();
}
catch(Exception ex)
{
oleDbTr.Rollback();
}