Handling Multi dimentional JSON Array in asp.net

Question

2.00/5 (1 vote)

See more:

C#

I want to parse JSON object returned from a web method. Please help me to do so.

Posted 24-Jun-13 23:07pm

sunpop

Updated 28-Jun-13 9:24am

v2

Add a Solution

Comments

Sunasara Imdadhusen 25-Jun-13 7:15am

What kind of your json object data or structure and what is the meaning of "Handling Multi dimentional JSON Array"

3 solutions

Solution 2

C#

HttpWebRequest request = (HttpWebRequest)WebRequest.Create("https://Your JSON URL");

                //&tracking_number=" + txtttnumber.Text + "&courier=" + ddlcourier.SelectedValue

                HttpWebResponse response = (HttpWebResponse)request.GetResponse();

                if (response.StatusCode == HttpStatusCode.OK)
                {
                    Stream receiveStream = response.GetResponseStream();
                    StreamReader readStream = null;

                    if (response.CharacterSet == null)
                        readStream = new StreamReader(receiveStream);
                    else
                        readStream = new StreamReader(receiveStream, Encoding.GetEncoding(response.CharacterSet));
                    //  List<string> list = new List<string>();
                     //Concert JSON objects in to string

                    string data = readStream.ReadToEnd();

                  //You can also convert string into dictionary

   Dictionary<string,object> dict = new JavaScriptSerializer().Deserialize<Dictionary<string,object>>(data);

//now  manipulate dictionary or string as per your need

}

Posted 25-Jun-13 1:32am

Nirav Prabtani

Updated 25-Jun-13 1:34am

v2

Comments

sjelen 25-Jun-13 9:59am

Good point, OP did not specify from where he will be consuming web service, I just assumed it's from browser.

Solution 1

There are many ways to parse JSON, for example:
http://api.jquery.com/jQuery.parseJSON/[^]
If you need more help you have to provide more details, including some code, how are you invoking web method, how does web method response look like...

Posted 25-Jun-13 1:17am

sjelen

Comments

sunpop 26-Jun-13 0:46am

I'm getting this Json array as result from a RESTful web method. The JSON array is as follows
{"response_list":[{"id_country":"302","label":"NICARAGUA"},{"id_country":"303","label":"NIGER"},{"id_country":"304","label":"NIG\u00c9RIA"},{"id_country":"305","label":"NIU\u00c9"},{"id_country":"306","label":"NORFOLK, \u00ceLE"},{"id_country":"307","label":"NORV\u00c8GE"},{"id_country":"308","label":"NOUVELLE-CAL\u00c9DONIE"},{"id_country":"341","label":"SAINT-VINCENT-ET-LES GRENADINES"},{"id_country":"342","label":"SALOMON, \u00ceLES"},{"id_country":"343","label":"SAMOA"},{"id_country":"344","label":"SAMOA AM\u00c9RICAINES"},],"response_status":{"message":"Success","status":0}}
I need to take the "label" & populate in a dropdown list. This is what I mean by handling JSON multi dimensional array.

sunpop 26-Jun-13 0:52am

@Nirav Prabtani
Thank you for the solution. But I could not include namespace of JavaScriptSerializer (ie.,I'm unable to add 'using system.web.script.serialization'. I searched for it's dll & I could not find it)Could you please help.

sjelen 26-Jun-13 4:49am

JavaScripSerializer is available since .NET 3.5 and you need to reference System.Web.Extensions.dll

You could also use a very popular library Json.NET: http://james.newtonking.com/pages/json-net.aspx
or if you don't want 3rd party library you can use System.Runtime.Serialization.Json.DataContractJsonSerializer class:
http://msdn.microsoft.com/en-us/library/system.runtime.serialization.json.datacontractjsonserializer.aspx

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

sunpop · Accepted Answer · 2013-09-18T07:57:00

I parse the JSon object through JQuery as follows:

C#

var jsonArr = $("#jsonOutput").val();
   if (jsonArr.toString() != "")
    {  var stType = JSON.parse(jsonArr2);
       var strType = $('#strType');
       strType.append($('<option></option>').val('0').html('--Select--'));
       for (i = 0; i < stType.response_list.length; i++) {
           strType.append($('<option></option>').val(stType.response_list[i].code).html(stType.response_list[i].label));
       }
   }

Handling Multi dimentional JSON Array in asp.net

3 solutions

Solution 2

Solution 1

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us