BAGCST.api.FoodMenu.Database.onlinePlaceDB.getPlaces C# (CSharp) Method

        public PlaceItem[] getPlaces()
        {
            sqlConnection = null;
            sqlConnection = TimeTableDatabase.getConnection();
            try
            {
                using (sqlConnection)
                {
                    PlaceItem SQLItem = new PlaceItem();
                    List<PlaceItem> ListPlaceItem = new List<PlaceItem>();
                    string SQL = "SELECT [foodplaceid],[name] FROM [foodplace] " +
                        " ;";

                    sqlConnection.Open();
                    SqlDataReader myReader = null;
                    SqlCommand myCommand = new SqlCommand(SQL, sqlConnection);
                    myReader = myCommand.ExecuteReader();

                    while (myReader.Read())
                    {
                        SQLItem.PlaceID = Convert.ToInt32(myReader["foodplaceid"]);
                        SQLItem.PlaceName = myReader["name"].ToString();
                        ListPlaceItem.Add(SQLItem);
                        SQLItem = new PlaceItem();
                    }

                        sqlConnection.Close();
                        sqlConnection = null;
                        return ListPlaceItem.ToArray();
                }

            }
            catch (System.Exception)
            {
                return null;
            }
        }