public void CommitTransaction() { try { ps.CommitTransaction(); } catch (Exception) { ps.RollBackTRansaction(); throw; } }