How to extract data from JSON in ASP.NET using c#

Question

{"pometek.net":{"status":"available","classkey":"dotnet"},"pometek.com":{"status":"available","classkey":"domcno"}}

I want to dispense this in table format. Need help.

You can deserialize it to IDictionary<string, string>, take a look at this SO question — Zbigniew
– Zbigniew, Commented Nov 1, 2012 at 10:24

Stefan P. · Accepted Answer · 2012-11-01 10:24:09Z

2

You can use Json.NET to deserialize the json object into a C# class, and then map that class to a table format in asp.net

answered Nov 1, 2012 at 10:24

Stefan P.

9,5196 gold badges32 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Rawling · Accepted Answer · 2012-11-01 10:34:37Z

1

You shouldn't need a third-party library; the out-of-the-box JavaScriptSerializer can handle this.

class Item {
    public string status { get; set; }
    public string classkey { get; set; }
}

var jss = new System.Web.Script.Serialization.JavaScriptSerializer();
var input = "{\"pometek.net\":{\"status\":\"available\",\"classkey\":\"dotnet\"},\"pometek.com\":{\"status\":\"available\",\"classkey\":\"domcno\"}}";
var results = jss.Deserialize<Dictionary<string, Item>(input);
var query = results["pometek.net"].status; // = "available"

Displaying this as a table is a separate step.

answered Nov 1, 2012 at 10:34

Rawling

50.3k7 gold badges94 silver badges131 bronze badges

Collectives™ on Stack Overflow

How to extract data from JSON in ASP.NET using c#

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related