public DataTable ExecuteQuery(string strQuery, SqlTransaction objTrans) { SqlCommand cmd = new SqlCommand(); DataAccessLayer objDataAccess = new DataAccessLayer(); try { cmd.CommandText = strQuery; cmd.Transaction = objTrans; cmd.Connection = objTrans.Connection; objDataAccess.Command = cmd; DataTable dt = new DataTable(); dt = objDataAccess.GetTable(); return dt; } catch (Exception ex) { throw ex; } finally { cmd.Dispose(); } }
public int getNoOfException(string strQuery, SqlTransaction objTrans) { SqlCommand cmd = new SqlCommand(); DataAccessLayer objDataAccess = new DataAccessLayer(); try { cmd.CommandText = strQuery; cmd.Transaction = objTrans; cmd.Connection = objTrans.Connection; objDataAccess.Command = cmd; DataTable dt = new DataTable(); dt = objDataAccess.GetTable(); return Convert.ToInt32(dt.Rows[0]["Rowcount"]); } catch (Exception ex) { throw ex; } finally { cmd.Dispose(); } }