Parse JSON output in asp.net MVC 3

Question

I want to parse JSON string in C# asp.net mVC3 but not getting idea of how to parse my json string. my JSON String is like that:

{"dept":"HR","data":[{"height":5.5,"weight":55.5},{"height":5.4,"weight":59.5},{"height":5.3,"weight":67.7},{"height":5.1,"weight":45.5}]}

Code:

var allData = { dept: deptname, data: arr};
var allDataJson = JSON.stringify(allData);
$.ajax({
 url: '<%=Url.Action("funx","Controller")%>',
 data: { DJson: allDataJson },
 async: false,
 cache: false,
 type: 'POST',
 success: function (data) {
 alert("success data: "+data);
 }
}); 
public String funx(string DJson)
{
 System.Diagnostics.Debug.WriteLine("Returned Json String:" + DJson);
 // var yourObject = new JavaScriptSerializer().Deserialize(DJson);
 return "successfull";
}

I am new to asp.net. I want to parse the string and save it in database.

• Sirwan Afifi: Use JSON.NET for parsing your json

Answer 1

Method 1:

Create two classes with the structure of your JSON string:

public class myobj
{
 public string dept;
 public IEnumerable<mydata>;
}
public class mydata
{
 public int weight;
 public int height;
}

and after that use this to parse it:

public static T FromJSON<T>(string str)
{
 JavaScriptSerializer serializer = new JavaScriptSerializer();
 return serializer.Deserialize<T>(str);
}

Like this:

myobj obj = MP3_SIOP_LT.Code.Helpers.JSONHelper.FromJSON<myobj>(@"{""dept"":""HR"",""data"":[{""height"":5.5,""weight"":55.5},{""height"":5.4,""weight"":59.5},{""height"":5.3,""weight"":67.7},{""height"":5.1,""weight"":45.5}]}");

The result:

enter image description here

Method 2:

If you don't want to have classes with your JSON structure, use the same method as above like this but in order to get a dynamic object:

dynamic obj = MP3_SIOP_LT.Code.Helpers.JSONHelper.FromJSON<dynamic>(@"{""dept"":""HR"",""data"":[{""height"":5.5,""weight"":55.5},{""height"":5.4,""weight"":59.5},{""height"":5.3,""weight"":67.7},{""height"":5.1,""weight"":45.5}]}");

The result:

enter image description here

Answer 2

First create a model for your json

public class Size
{
 public double height { get; set; }
 public double weight { get; set; }
}
public class MyData
{
 public string dept { get; set; }
 public List<Size> data { get; set; }
}

Now you can deserialize your json. With built-in DataContractJsonSerializer

var serializer = new DataContractJsonSerializer(typeof(MyData));
var data = (MyData)serializer.ReadObject(new MemoryStream(Encoding.UTF8.GetBytes(json)));

or With Json.Net

var data = JsonConvert.DeserializeObject<MyData>(json);

You can even go the dynamic way without creating any classes

dynamic dynObj = JsonConvert.DeserializeObject(json);
foreach(var item in dynObj.data)
{
 Console.WriteLine("{0} {1}", item.height, item.weight);
}

Answer 3

You can use NewtonSoft Json.Net for parsing.

Try this

var json = "{\"dept\":\"HR\",\"data\":[{\"height\":5.5,\"weight\":55.5},{\"height\":5.4,\"weight\":59.5},{\"height\":5.3,\"weight\":67.7},{\"height\":5.1,\"weight\":45.5}]}";
var foo = JsonConvert.DeserializeObject<RootObject>(json);
// Check Values
// var department = foo.dept;
// foreach (var item in foo.data)
// {
// var height = item.height;
// var weight = item.weight;
// }
public class Datum
{
 public double height { get; set; }
 public double weight { get; set; }
}
public class RootObject
{
 public string dept { get; set; }
 public List<Datum> data { get; set; }
}

Nuget: Json.Net