deserialize json in datatable from javascriptserializer

Question

Hi I have to parse json data into datatable object. Bellow is my json data

{

"Figurative Expressions (Idioms)" : {

 "A" : [
         {
            "One word" : "Above all",
            "Phrase" : "chiefly, before everything else"
         },
         {
            "One word" : "Above-board",
            "Phrase" : "not open to question, honest, straight-forward, beyond reproach"
         },
         {
            "One word" : "Above-par",
            "Phrase" : "of superior quality"
         },
         {
            "One word" : "On account of ",
            "Phrase" : "for the sake of"
         },
         {
            "One word" : "On no account",
            "Phrase" : "not for any reason"
         },
         {
            "One word" : "To give a good account of oneself",
            "Phrase" : "to act with credit to oneself"
         }
      ]
   }

}

How do we parse this json data in datatable?

As I tried with javascriptserializer, it was parsed successfully but didn't get anything in datatable.

JavaScriptSerializer js = new JavaScriptSerializer(); 
DataTable data1 = js.Deserialize<DataTable>(text);

What datatable? Which language are we talking about here? Show some more code -> what have you tried =) — Mario S
– Mario S, Commented Jan 22, 2013 at 8:21
I tried with bellow code: JavaScriptSerializer js = new JavaScriptSerializer(); DataTable data1 = js.Deserialize<DataTable>(text); — user1999529
– user1999529, Commented Jan 22, 2013 at 8:24
You can try using Json.Net. See this question and answer: How to convert json into datatable? — Mario S
– Mario S, Commented Jan 22, 2013 at 8:40
I tried with Json.Net and getting this error "Additional text found in JSON string after finishing deserializing object." — user1999529
– user1999529, Commented Jan 22, 2013 at 9:13

Jano · Accepted Answer · 2013-01-22 10:06:13Z

0

It could be due to the fact that the Json in your example is not a pure array - but rather an object with one attribute called A which is the actual array.

My suggestion is to try to deserialize only text that defines A attribute (starting with square bracket) - so pure Json array. This should deserialise into a Datatable fine.

answered Jan 22, 2013 at 10:06

Jano

1812 silver badges8 bronze badges

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

Collectives™ on Stack Overflow

deserialize json in datatable from javascriptserializer

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related