how can I check what transaction's status is???Code:try { conne = DbManager.getConnection(); conne.Open(); trans = conne.BeginTransaction(); cmd = new SqlCommand(statement, conne, trans); foreach (SqlParameter _param in parameters) { cmd.Parameters.Add(_param); } cmd.CommandType = commandBehavior; reader = cmd.ExecuteReader(); } catch (SqlException) { conne. } finally { return reader; }