Windows Phone and Bing Maps Pushpin Location from JSON (PHP/MySQL)

public class MyLocation
{
    public double Lat { get; set; }
    public double Lon { get; set; }
    public string LocationName { get; set; }
}

/* [{"Lat":"13.815361","Lon":"100.560822","LocationName":"Central Patpharo"},{"Lat":"13.81433","Lon":"100.560162","LocationName":"MRT Phaholyothin"}] */
string strJSON = string.Empty;
strJSON = " [{\"Lat\":\"13.815361\",\"Lon\":\"100.560822\",\"LocationName\":\"Central Patpharo\"},{\"Lat\":\"13.81433\",\"Lon\":\"100.560162\",\"LocationName\":\"MRT Phaholyothin\"}]";

MemoryStream ms = new MemoryStream(Encoding.UTF8.GetBytes(strJSON));
ObservableCollection<MyLocation> list = new ObservableCollection<MyLocation>();
DataContractJsonSerializer serializer = new DataContractJsonSerializer(typeof(ObservableCollection<MyLocation>));
list = (ObservableCollection<MyLocation>)serializer.ReadObject(ms);

foreach (MyLocation loc in list)
{
    loc.Lat;
    loc.Lon;
}

                Pushpin pushpin1 = new Pushpin();
                pushpin1.GeoCoordinate = new GeoCoordinate(loc.Lat, loc.Lon);
                pushpin1.Background = new SolidColorBrush(Colors.Orange);
                MapOverlay overlay1 = new MapOverlay();
                overlay1.Content = pushpin1;
                overlay1.GeoCoordinate = new GeoCoordinate(loc.Lat, loc.Lon);
                layer.Add(overlay1);

using Microsoft.Phone.Maps.Controls;
using Microsoft.Phone.Maps.Toolkit;
using System.Device.Location;
using Windows.Devices.Geolocation;
using System.Windows.Shapes;
using System.Windows.Media;

using System.Xml.Linq;
using System.Runtime.Serialization;
using System.Runtime.Serialization.Json;
using System.Collections.ObjectModel;
using System.Text;
using System.IO;


namespace myPhoneApp
{
    public class MyLocation
    {
        public double Lat { get; set; }
        public double Lon { get; set; }
        public string LocationName { get; set; }
    }

    public partial class MainPage : PhoneApplicationPage
    {
        // Constructor
        public MainPage()
        {
            InitializeComponent();

            this.LoadMap();
        }

        protected void LoadMap()
        {

            //*** Map
            Map MyMap = new Map();
            MyMap.ZoomLevel = 16;

            MapLayer layer = new MapLayer();

            /* [{"Lat":"13.815361","Lon":"100.560822","LocationName":"Central Patpharo"},{"Lat":"13.81433","Lon":"100.560162","LocationName":"MRT Phaholyothin"}] */
            string strJSON = string.Empty;
            strJSON = " [{\"Lat\":\"13.815361\",\"Lon\":\"100.560822\",\"LocationName\":\"Central Patpharo\"},{\"Lat\":\"13.81433\",\"Lon\":\"100.560162\",\"LocationName\":\"MRT Phaholyothin\"}]";

            MemoryStream ms = new MemoryStream(Encoding.UTF8.GetBytes(strJSON));
            ObservableCollection<MyLocation> list = new ObservableCollection<MyLocation>();
            DataContractJsonSerializer serializer = new DataContractJsonSerializer(typeof(ObservableCollection<MyLocation>));
            list = (ObservableCollection<MyLocation>)serializer.ReadObject(ms);

            foreach (MyLocation loc in list)
            {
                Pushpin pushpin1 = new Pushpin();
                pushpin1.GeoCoordinate = new GeoCoordinate(loc.Lat, loc.Lon);
                pushpin1.Background = new SolidColorBrush(Colors.Orange);
                MapOverlay overlay1 = new MapOverlay();
                overlay1.Content = pushpin1;
                overlay1.GeoCoordinate = new GeoCoordinate(loc.Lat, loc.Lon);
                layer.Add(overlay1);

                MyMap.Center = new GeoCoordinate(loc.Lat, loc.Lon);
            }


            // Map Layer
            MyMap.Layers.Add(layer);

            // CarphicMode
            MyMap.CartographicMode = MapCartographicMode.Hybrid;

            // Add map to display
            ContentPanel.Children.Add(MyMap);

        }

    }
}

CREATE TABLE `location` (
  `LocationID` int(2) NOT NULL auto_increment,
  `Latitude` double NOT NULL,
  `Longitude` double NOT NULL,
  `LocationName` varchar(255) NOT NULL,
  PRIMARY KEY  (`LocationID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;


INSERT INTO `location` VALUES (1, 13.815361, 100.560822, 'Central Patpharo');
INSERT INTO `location` VALUES (2, 13.81433, 100.560162, 'MRT Phaholyothin');
INSERT INTO `location` VALUES (3, 13.801525, 100.547523, 'Chatuchak Park');
INSERT INTO `location` VALUES (4, 13.799941, 100.552502, 'BTS Chatuchak');
INSERT INTO `location` VALUES (5, 13.799941, 100.552502, 'MRT Chatuchak ');
INSERT INTO `location` VALUES (6, 13.805859, 100.57353, 'MRT Latpharo');

<?php
	$objConnect = mysql_connect("localhost","root","root");
	$objDB = mysql_select_db("mydatabase");

	$strSQL = "SELECT * FROM location WHERE 1 ";

	$objQuery = mysql_query($strSQL);
	$intNumField = mysql_num_fields($objQuery);
	$resultArray = array();
	while($obResult = mysql_fetch_array($objQuery))
	{
		$arrCol = array();
		for($i=0;$i<$intNumField;$i++)
		{
			$arrCol[mysql_field_name($objQuery,$i)] = $obResult[$i];
		}
		array_push($resultArray,$arrCol);
	}
	
	mysql_close($objConnect);
	
	echo json_encode($resultArray);
?>

public class MyLocation
{
    public int LocationID { get; set; }
    public double Latitude { get; set; }
    public double Longitude { get; set; }
    public string LocationName { get; set; }
}

        public MainPage()
        {
            InitializeComponent();

            string url = "http://localhost/myweb/getJSON.php";
            Uri uri = new Uri(url);
            client = new WebClient();
            client.AllowReadStreamBuffering = true;

            client.DownloadStringCompleted += client_DownloadStringCompleted;

            client.DownloadStringAsync(uri);
        }

        private void client_DownloadStringCompleted(object sender, DownloadStringCompletedEventArgs e)
        {
		string strJSON = Convert.ToString(e.Result);
        }

MemoryStream ms = new MemoryStream(Encoding.UTF8.GetBytes(strJSON));
ObservableCollection<MyLocation> list = new ObservableCollection<MyLocation>();
DataContractJsonSerializer serializer = new DataContractJsonSerializer(typeof(ObservableCollection<MyLocation>));
list = (ObservableCollection<MyLocation>)serializer.ReadObject(ms);

foreach (MyLocation loc in list)
{
    loc.Lat;
    loc.Lon;
}

                foreach (MyLocation loc in list)
                {
                    Pushpin pushpin1 = new Pushpin();
                    pushpin1.GeoCoordinate = new GeoCoordinate(loc.Latitude, loc.Longitude);
                    pushpin1.Background = new SolidColorBrush(Colors.Orange);
                    MapOverlay overlay1 = new MapOverlay();
                    overlay1.Content = pushpin1;
                    overlay1.GeoCoordinate = new GeoCoordinate(loc.Latitude, loc.Longitude);
                    layer.Add(overlay1);

                    MyMap.Center = new GeoCoordinate(loc.Latitude, loc.Longitude);
                }

using Microsoft.Phone.Maps.Controls;
using Microsoft.Phone.Maps.Toolkit;
using System.Device.Location;
using Windows.Devices.Geolocation;
using System.Windows.Shapes;
using System.Windows.Media;

using System.Xml.Linq;
using System.Runtime.Serialization;
using System.Runtime.Serialization.Json;
using System.Collections.ObjectModel;
using System.Text;
using System.IO;


namespace myPhoneApp
{
    public class MyLocation
    {
        public int LocationID { get; set; }
        public double Latitude { get; set; }
        public double Longitude { get; set; }
        public string LocationName { get; set; }
    }

    public partial class MainPage : PhoneApplicationPage
    {

  
        WebClient client;
        // Constructor
        public MainPage()
        {
            InitializeComponent();

            string url = "http://localhost/myweb/getJSON.php";
            Uri uri = new Uri(url);
            client = new WebClient();
            client.AllowReadStreamBuffering = true;

            client.DownloadStringCompleted += client_DownloadStringCompleted;

            client.DownloadStringAsync(uri);
        }

        private void client_DownloadStringCompleted(object sender, DownloadStringCompletedEventArgs e)
        {

            if (e.Cancelled == false && e.Error == null)
            {
                string strJSON = Convert.ToString(e.Result);

                //*** Map
                Map MyMap = new Map();
                MyMap.ZoomLevel = 14;

                MapLayer layer = new MapLayer();

                MemoryStream ms = new MemoryStream(Encoding.UTF8.GetBytes(strJSON));
                ObservableCollection<MyLocation> list = new ObservableCollection<MyLocation>();
                DataContractJsonSerializer serializer = new DataContractJsonSerializer(typeof(ObservableCollection<MyLocation>));
                list = (ObservableCollection<MyLocation>)serializer.ReadObject(ms);

                foreach (MyLocation loc in list)
                {
                    Pushpin pushpin1 = new Pushpin();
                    pushpin1.GeoCoordinate = new GeoCoordinate(loc.Latitude, loc.Longitude);
                    pushpin1.Background = new SolidColorBrush(Colors.Orange);
                    MapOverlay overlay1 = new MapOverlay();
                    overlay1.Content = pushpin1;
                    overlay1.GeoCoordinate = new GeoCoordinate(loc.Latitude, loc.Longitude);
                    layer.Add(overlay1);

                    MyMap.Center = new GeoCoordinate(loc.Latitude, loc.Longitude);
                }


                // Map Layer
                MyMap.Layers.Add(layer);

                // CarphicMode
                MyMap.CartographicMode = MapCartographicMode.Hybrid;

                // Add map to display
                ContentPanel.Children.Add(MyMap);

            }

        }

    }
}