System.Data.OleDb.OleDbTransaction trans=null;
System.Data.OleDb.OleDbConnection conn1=baseclass.basedata.open("dictdb");
conn1.Open();
trans = conn1.BeginTransaction(IsolationLevel.ReadCommitted);
try
{
System.Data.OleDb.OleDbCommand command=new System.Data.OleDb.OleDbCommand();
command.CommandText="delete from service_state where id='"+sid+"'";
command.Transaction=trans;
command.Connection=conn1;
command.ExecuteNonQuery();
trans.Commit();
}
catch
{
trans.Rollback();
}
finally
{
conn1.Close();
}
System.Data.OleDb.OleDbConnection conn1=baseclass.basedata.open("dictdb");
conn1.Open();
trans = conn1.BeginTransaction(IsolationLevel.ReadCommitted);
try
{
System.Data.OleDb.OleDbCommand command=new System.Data.OleDb.OleDbCommand();
command.CommandText="delete from service_state where id='"+sid+"'";
command.Transaction=trans;
command.Connection=conn1;
command.ExecuteNonQuery();
trans.Commit();
}
catch
{
trans.Rollback();
}
finally
{
conn1.Close();
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货