SIAQ.DataAccess.Object.DAOcupacion.SelectMotivo C# (CSharp) Method

        public DataSet SelectMotivo(ENTOcupacion oENTOcupacion, string ConnectionString)
        {
            DataSet ResultData = new DataSet();
            SqlConnection Connection = new SqlConnection(ConnectionString);
            SqlCommand Command;
            SqlParameter Parameter;
            SqlDataAdapter DataAdapter;

            try
            {
                Command = new SqlCommand("uspcatOcupacion_Sel", Connection);
                Command.CommandType = CommandType.StoredProcedure;

                Parameter = new SqlParameter("OcupacionId", SqlDbType.Int);
                Parameter.Value = oENTOcupacion.OcupacionId;
                Command.Parameters.Add(Parameter);

                Parameter = new SqlParameter("Nombre", SqlDbType.VarChar);
                Parameter.Value = oENTOcupacion.Nombre;
                Command.Parameters.Add(Parameter);

                DataAdapter = new SqlDataAdapter(Command);
                ResultData = new DataSet();

                Connection.Open();
                DataAdapter.Fill(ResultData);
                Connection.Close();

                return ResultData;
            }
            catch (SqlException Exception)
            {
                _ErrorId = Exception.Number;
                _ErrorDescription = Exception.Message;

                if (Connection.State == ConnectionState.Open)
                    Connection.Close();

                return ResultData;
            }
        }

 public DataSet SelectOcupacion(ENTOcupacion oENTOcupacion)
 {
     string ConnectionString = string.Empty;
        DAOcupacion oDAOcupacion = new DAOcupacion();
        ConnectionString = sConnectionApplication;
        _OcupacionEntity.ResultData = oDAOcupacion.SelectMotivo(_OcupacionEntity, ConnectionString);
        return _OcupacionEntity.ResultData;
 }