// ////////////////////////////////////////////////////////////////////////
 // PUBLIC METHODS
 //
 /// <summary>
 /// Load
 /// </summary>
 /// <param name="whereClause">whereClause</param>
 /// <param name="orderByClause">orderByClause</param>
 public void Load(string whereClause, string orderByClause)
 {
     RevenueNavigatorGateway RevenueNavigatorGateway = new RevenueNavigatorGateway(Data);
     RevenueNavigatorGateway.LoadWhereOrderBy(whereClause, orderByClause);
 }
        private RevenueNavigatorTDS SubmitSearch()
        {
            // Retrieve clauses
            string whereClause = GetWhereClause();
            string orderByClause = GetOrderByClause();

            RevenueNavigatorTDS dataSet = new RevenueNavigatorTDS();
            RevenueNavigatorGateway revenueNavigatorGateway = new RevenueNavigatorGateway(dataSet);

            //... Load data
            RevenueNavigator revenueNavigator = new RevenueNavigator(dataSet);
            revenueNavigator.Load(whereClause, orderByClause);

            return dataSet;
        }