public void CommitTransaction()
{
if(m_oTransaction == null)
throw(new Exception("BeginTransaction must be called before commit or rollback. No open transactions found"));
m_oTransaction.Commit();
m_oTransaction.Dispose();
m_oTransaction = null;
}