JSON Parsing in Windows Phone using C#

Ramesh Maruthi12y ago

Accepted answer

I am unable to connect your team viewer

string s = Convert.ToString(e.Result);

DataContractJsonSerializer serializer = new DataContractJsonSerializer(typeof(List));

MemoryStream ms = new MemoryStream(

Encoding.UTF8.GetBytes(s));

var list = (List)serializer.ReadObject(ms);

TaskListBox.ItemsSource= list

0

Zia ur Rehman11y ago

This link will make easy your life using JSON.

http://nkishorchandra.blogspot.com/2012/10/parsing-json-in-windows-phone.html#comment-form

0

Ramesh Maruthi12y ago

Here is the code dude

private void Updates_SelectionChanged(object sender, SelectionChangedEventArgs e)

{

int index = Updates.SelectedIndex;

MessageBox.Show("Index" + index);

if (Updates.SelectedIndex == -1)

return;

else

{

Earthquake s = (Earthquake) e.AddedItems[0];

string url = s.link;

WebBrowserTask webBrowserTask = new WebBrowserTask();

webBrowserTask.Uri = new Uri(url, UriKind.RelativeOrAbsolute);

webBrowserTask.Show();

}

0

Aditya Patil12y ago

WebBrowserTask webBrowserTask = new WebBrowserTask();
webBrowserTask.Uri = new Uri(eop.link, UriKind.RelativeOrAbsolute);
webBrowserTask.Show();

What parameter should pass at eop.link. When I click on 1st Index of listbox, its link should open in WebBrowser, if click on 5th Data then link of 5th should get open.
Can anyone tell me the parameter so that it can take link of selected index. Please.

0

Aditya Patil12y ago

Hey,
I Binded properly all data to the Listbox, and arranged in well mannner Atlast, the big data can be seen in the whole screen too,

I want more help now, getting stucked, When I will click on one data or value it contain one link too, I want to User should navigate to that link. How I can do that?

0

Ramesh Maruthi12y ago

hey Aditya,

I agree with you and I know about Json.Net before 6 months it self when I used to work with mongodb using c# yesterday I was using trail windows sdk that to 2010 so it's hard to install extended packages, I didn't find Nuget to do that anyways thanks once again it's good sharing knowledge with you and I have seen ur hard work and trouble as newbie keep going buddy all the best :)

0

Aditya Patil12y ago

For JSON Parsing, whatever you did its right, but I think its long method.
For parsing JSON content in the Windows Phone app, there is Reference Json.NET which we can add in the references so it may be easy and least number of steps to parse JSON.

Also I heard there is SimpleJson Reference id there nwhich also can help us to parse JSON easily, no need to create Serializer and MemoryStream.

So if you want to research go for Json.NET of Newtonsoft.JSON. may be helpful for us.

0

Aditya Patil12y ago

Atlast worked for me too
Thanx @Ramesh Sir for your big help

0

Ramesh Maruthi12y ago

string s = Convert.ToString(e.Result);

//IEnumerable resu;

DataContractJsonSerializer serializer = new DataContractJsonSerializer(typeof(IEnumerable));

MemoryStream ms = new MemoryStream(

Encoding.UTF8.GetBytes(s));

var list = (IEnumerable)serializer.ReadObject(ms);

List datasource = new List();

//Earthquakelist eyp = new Earthquakelist();

foreach (Earthquake eop in list)

{

datasource.Add(new Earthquake{title =eop.title, magnitude = eop.magnitude,location=eop.location,depth=eop.depth,latitude=eop.latitude,longitude=eop.longitude,date_time=eop.date_time,link=eop.link});

}

listBox1.ItemsSource = datasource;

0

Ramesh Maruthi12y ago

Dude its working for me now :)

0

Aditya Patil12y ago

I moved to other system try here, if worked here, check the code I written right or not?
Please Join me
Teamviewer details
593 940 517
6840

0

Ramesh Maruthi12y ago

Sorry Aditya, Even I tried on mine pc, its not displaying the Earthquake class items, Its just displaying as EarthQuake as 32 times but in program at TaskListbox it showing me even the values but dont know y its not displaying there :(

0

Aditya Patil12y ago

I tried above code, its not showing the Earthquake details on screen

Teamviewer details
593 940 517
6840

0

Aditya Patil12y ago

944 847 769
3257

0

Ramesh Maruthi12y ago

Give your team viewer details

0

Aditya Patil12y ago

namespace Earthquake_Updates
{
    public partial class MainPage : PhoneApplicationPage
    {

        // Constructor
        public MainPage()
        {
            InitializeComponent();
            WebClient webClient = new WebClient();
            webClient.DownloadStringCompleted += webClient_DownloadStringCompleted;
            ProgressBarRequest.Visibility = System.Windows.Visibility.Visible;
            webClient.DownloadStringAsync(new Uri("http://earthquake-report.com/feeds/recent-eq?json"));
        }

        void webClient_DownloadStringCompleted(object sender, DownloadStringCompletedEventArgs e)
        {
            try
            {
                if (!string.IsNullOrEmpty(e.Result))
                {
                    //Parse JSON result
                    List jsondata = JsonConvert.DeserializeObject>(e.Result).ToList(); ;
                    foreach (Earthquake q in jsondata)
                    {
                        TaskListBox.ItemsSource = new Earthquakelist { Add(new Earthquake { title = q.title, magnitude = q.magnitude, location = q.location, depth = q.depth, latitude = q.latitude, longitude = q.longitude, date_time = q.date_time, link = q.link }) };
                    }
                }

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
            finally
            {
                ProgressBarRequest.Visibility = System.Windows.Visibility.Collapsed;
            }
        }
    }
    public class Earthquakelist : List
    {   }
    public class Earthquake
    {
        public string title { get; set; }
        public string magnitude { get; set; }
        public string location { get; set; }
        public string depth { get; set; }
        public string latitude { get; set; }
        public string longitude { get; set; }
        public string date_time { get; set; }
        public string link { get; set; }
    }
}

My Current code, Error still persist on Add,
As dzone link they added all items in public class

MovieList : List
Same way I tried to add all in public class Earthquakelist : List
    {   }
Its shows error to jsondata

0

Aditya Patil12y ago

Still Error remains at Add??
it creates new stub of Add

0

Ramesh Maruthi12y ago

Aditya,

Please try to implement in this way

http://dotnet.dzone.com/news/how-bind-data-listbox-windows

0

Aditya Patil12y ago

Error for Add

Error 2 The name 'Add' does not exist in the current context C:\Users\Aditya\Desktop\Earthquake Updates\Earthquake Updates\Earthquake Updates\MainPage.xaml.cs 37 72 Earthquake Updates

0

Ramesh Maruthi12y ago

ok try in this way final

public class Earthquake

{

public string title { get; set; }

public string magnitude { get; set; }

public string location { get; set; }

public string depth { get; set; }

public string latitude { get; set; }

public string longitude { get; set; }

public string date_time { get; set; }

public string link { get; set; }

}

public class Earthquakelist:List

{

}

foreach(Earthquake q in jsondata )

{

TaskListBox.ItemsSource = new Earthquakelist{Add (new Earthquake {title = q.title, magnitude = q.magnitude, location=q.location, depth=q.depth, latitude=q.latitude,longitude=q.longitude,date_time=q.date_time,link = q.link})};
}

+1

Aditya Patil12y ago

I closed it still same error at TaskListBox.ItemsSource = new Earthquake()
Screenshot: http://prntscr.com/45ke4t
Error Message,
Error 2 Cannot implicitly convert type 'Earthquake_Updates.Earthquake' to 'System.Collections.IEnumerable'. An explicit conversion exists (are you missing a cast?) C:\Users\Aditya\Desktop\Earthquake Updates\Earthquake Updates\Earthquake Updates\MainPage.xaml.cs 37 51 Earthquake Updates

Error Screen: http://prntscr.com/45kekh

0

Ramesh Maruthi12y ago

TaskListBox.ItemsSource = new Earthquake(){title = q.title, magnitude = q.magnitude, location=q.location, depth=q.depth, latitude=q.latitude,longitude=q.longitude,date_time=q.date_time,link = q.link};

SORRY close with flower brace and try it once if not I have another idea lets c with that

+1

Aditya Patil12y ago

Getting Error
Error    8    Cannot implicitly convert type 'Earthquake_Updates.MainPage.Earthquake' to 'System.Collections.IEnumerable'. An explicit conversion exists (are you missing a cast?)    C:\Users\Aditya\Desktop\Earthquake Updates\Earthquake Updates\Earthquake Updates\MainPage.xaml.cs    37    51    Earthquake Updates

for below code
if (!string.IsNullOrEmpty(e.Result))
                {
                    //Parse JSON result
                    List jsondata = JsonConvert.DeserializeObject>(e.Result);
                    foreach(Earthquake q in jsondata)
                    {
                        TaskListBox.ItemsSource = new Earthquake(){title = q.title, magnitude = q.magnitude, location=q.location, depth=q.depth, latitude=q.latitude,longitude=q.longitude,date_time=q.date_time,link = q.link); //Error here
                    }
                }

0

Ramesh Maruthi12y ago

did u try the above for each loop ?

+1

Aditya Patil12y ago

See Screenshot
http://prntscr.com/45k8l5

0

Ramesh Maruthi12y ago

Hello Aditya,

Can you paste at least 2 items from a list of result json data what your getting at that point ?

And can you give a try like this

List jsondata = JsonConvert.DeserializeObject>(e.Result);

foreach(Earthquake q in jsondata )

{

TaskListBox.ItemsSource = new Earthquake() {title = q.title, magnitude = q.magnitude,............link =q.link)

}

+1

Aditya Patil12y ago

@Ramesh,

I changed few code and then tried but I am not getting how to bind the data to the ListBox, so help me.
List jsondata = JsonConvert.DeserializeObject>(e.Result);
I changed this code of line.

My Whole code looks like this
namespace Earthquake_Updates
{
    public partial class MainPage : PhoneApplicationPage
    {
        // Constructor
        public MainPage()
        {
            InitializeComponent();
            WebClient webClient = new WebClient();
            webClient.DownloadStringCompleted += webClient_DownloadStringCompleted;
            ProgressBarRequest.Visibility = System.Windows.Visibility.Visible;
            webClient.DownloadStringAsync(new Uri("http://earthquake-report.com/feeds/recent-eq?json"));
        }

        void webClient_DownloadStringCompleted(object sender, DownloadStringCompletedEventArgs e)
        {
            try
            {
                if (!string.IsNullOrEmpty(e.Result))
                {
                    //Parse JSON result
                    List jsondata = JsonConvert.DeserializeObject>(e.Result);
                    TaskListBox.ItemsSource = jsondata;
                }

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
            finally
            {
                ProgressBarRequest.Visibility = System.Windows.Visibility.Collapsed;
            }
        }
    }

    public class Earthquake
    {
        public string title { get; set; }
        public string magnitude { get; set; }
        public string location { get; set; }
        public string depth { get; set; }
        public string latitude { get; set; }
        public string longitude { get; set; }
        public string date_time { get; set; }
        public string link { get; set; }
    }
}

I think jsondata getting whole data but how nto bind it with ListBox that don't know. So please solve that, and Check code too that I am right or not?

0

Aditya Patil12y ago

When I run app on 2G network got above exception but Now I tried my app on Wifi, the Exception is changed. Now I am getting below Exception

Unhandled Exception: Newtonsoft.Json.JsonSerializationException: Cannot deserial ize the current JSON object (e.g. {"name":"value"}) into type 'System.Collection s.Generic.List`1[ApiPost.position]' because the type requires a JSON array (e.g. [1,2,3]) to deserialize correctly. To fix this error either change the JSON to a JSON array (e.g. [1,2,3]) or chang e the deserialized type so that it is a normal .NET type (e.g. not a primitive t ype like integer, not a collection type like an array or List) that can be de serialized from a JSON object. JsonObjectAttribute can also be added to the type to force it to deserialize from a JSON object. Path 'positions', line 1, position 13. at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateObject(Js onReader reader, Type objectType, JsonContract contract, JsonProperty member, Js onContainerContract containerContract, JsonProperty containerMember, Object exis tingValue) at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateValueInte rnal(JsonReader reader, Type objectType, JsonContract contract, JsonProperty mem ber, JsonContainerContract containerContract, JsonProperty containerMember, Obje ct existingValue) at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.Deserialize(Jso nReader reader, Type objectType, Boolean checkAdditionalContent) at Newtonsoft.Json.JsonSerializer.DeserializeInternal(JsonReader reader, Type objectType) at Newtonsoft.Json.JsonConvert.DeserializeObject(String value, Type type, Jso nSerializerSettings settings) at Newtonsoft.Json.JsonConvert.DeserializeObject[T](String value, JsonSeriali zerSettings settings)

0

Aditya Patil12y ago

namespace Earthquake_Updates
{
public partial class MainPage : PhoneApplicationPage
{
// Constructor
public MainPage()
{
InitializeComponent();
WebClient webClient = new WebClient();
webClient.DownloadStringCompleted += webClient_DownloadStringCompleted;
ProgressBarRequest.Visibility = System.Windows.Visibility.Visible;
webClient.DownloadStringAsync(new Uri("http://earthquake-report.com/feeds/recent-eq?json"));
}

void webClient_DownloadStringCompleted(object sender, DownloadStringCompletedEventArgs e)
{
try
{
if (!string.IsNullOrEmpty(e.Result))
{
//Parse JSON result
var root1 = JsonConvert.DeserializeObject(e.Result);
this.DataContext = root1;

TaskListBox.ItemsSource = root1.title;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
ProgressBarRequest.Visibility = System.Windows.Visibility.Collapsed;
}
}
}
public class Earthquake
{
public string title { get; set; }
public string magnitude { get; set; }
public string location { get; set; }
public string depth { get; set; }
public string latitude { get; set; }
public string longitude { get; set; }
public string date_time { get; set; }
public string link { get; set; }
}
}

What is wrong in Above code, I am getting below Exception.

0

Aditya Patil12y ago

I am not understanding it at all, also no proper information is available to parse JSON link to Windows Phone app, Simple but Sweet.
I am completely new to JSON and parsing of it.

0

Ramesh Maruthi12y ago

Hello Aditya,

Can you try in this way, it just an example

http://stackoverflow.com/questions/18120092/how-to-parse-the-json-data-in-windows-phone-8

http://blogs.msdn.com/b/wsdevsol/archive/2013/09/04/how-to-store-json-data-in-windows-phone-8.aspx

+1