asp.net mysql 事务_MySQL（asp.net） 事务

try

{

string _conStr = "Driver={MySQL ODBC 3.51

Driver};server=localhost;database=test;uid=test;password=1;option=3";

OdbcConnection _odbcCon = new OdbcConnection(_conStr);

_odbcCon.Open();

OdbcTransaction trans = _odbcCon.BeginTransaction

(IsolationLevel.ReadCommitted);

OdbcCommand cmd = new OdbcCommand();

cmd.Connection = trans.Connection;

cmd.Transaction = trans;

string _sqlStr = "";

try

{

_sqlStr = "update  test ....."

cmd.CommandText = _sqlStr;

cmd.ExecuteNonQuery();

_sqlStr = "";

}

catch

{

trans.Rollback();

_odbcCon.Close();

hidsysMsg.Value = "Saving Failed!";                return;            }            trans.Commit();            _odbcCon.Close();                   }        catch (Exception e)        {            throw e;        }