public List <Gym> GetAllGymsByStars()
    {
        gymDataTableAdapters.gymsTableAdapter gymsTableAdapter = new gymDataTableAdapters.gymsTableAdapter();
        DataTable  gymsDataTable = gymsTableAdapter.getAllGymsByStars();
        List <Gym> gyms          = new List <Gym>();

        foreach (DataRow row in gymsDataTable.Rows)
        {
            Gym gym = new Gym();
            gym.Name = row["name"].ToString();
            gyms.Add(gym);
        }
        return(gyms);
    }
    public gymArray[] getAllGymsByStars()
    {
        int count = 0;

        gymDataTableAdapters.gymsTableAdapter gymsTableAdapter = new gymDataTableAdapters.gymsTableAdapter();
        DataTable gymsDataTable = gymsTableAdapter.getAllGymsByStars();

        gymArray[] gymArray = new gymArray[gymsDataTable.Rows.Count];

        foreach (DataRow row in gymsDataTable.Rows)
        {
            gymArray[count]      = new gymArray();
            gymArray[count].name = row["name"].ToString();
            count++;
        }
        return(gymArray);
    }