Extract data from a string

Question

I have a data string as

 [{"Name":"Jon","Age":"30"},{"Name":"Smith","Age":"25"}]

How to extract the data from it?

Please suggest me.

https://msdn.microsoft.com/nl-nl/library/9b9dty7d.aspx not to be rude, but have you tried googling? — Strah Behry, Apr 28 '16 at 19:26

score 1 · Answer 1 · answered Apr 28 '16 at 19:31

You need to deserialize the JSON into C# objects. Newtonsoft.Json is an excellent library for working with JSON.

public class Person
{
    public string Name { get; set; }
    public int Age { get; set; }
}

string json = @"{"Name":"Jon","Age":"30"}";

Person x = JsonConvert.DeserializeObject<Person>(json);

string name = x.Name;

score 1 · Accepted Answer · edited Apr 28 '16 at 20:51

Using builtin .NET classes, you can use System.Web.Extensions

public class Person
{
    public string Name { get; set; }
    public int Age { get; set; }
}

Then in your code, you can deserialise the JSON i.e.

public void GetPersonFromJson(string json)
{
    //...
    json = " [{\"Name\":\"Jon\",\"Age\":\"30\"},{\"Name\":\"Smith\",\"Age\":\"25\"}]";

    JavaScriptSerializer oJS = new JavaScriptSerializer();
    Person[] person = oJS.Deserialize<Person[]>(json);
    //...
}

Or using NewtonSoft Nuget package:

public class Person
{
    public string Name { get; set; }
    public int Age { get; set; }
}

Again in your code, you can deserialise using the NewtonSoft library i.e.

public void GetPersonFromJson(string json)
{
    //...
    json = " [{\"Name\":\"Jon\",\"Age\":\"30\"},{\"Name\":\"Smith\",\"Age\":\"25\"}]";
    var people = JsonConvert.DeserializeObject<List<Person>>(json);
    //...
}

Extract data from a string

2 Answers2