Json deserialising.

Question

I am stuck with trying to deserialize this json data.I tried with javascriptserializer() but i was only able to extract the first array..How to get the deserilize entire array..here is a part of my json data: { cols: [ { id: A label:  type: number pattern: General } { id: B label:  type: string } { id: C label:  type: string } { id: D label:  type: string } { id: E label:  type: string } ] rows: [ { c: [ { v: 1.0 f: 1 } { v: P24329 } { v: KMHCT41B1FU652568 } { v: 971564051696 } { v: Saad } ] } { c: [ { v: 2.0 f: 2 } { v: I79066 } { v: KMHDG4IE1FU108574 } { v: 971565187414 } { v: Saad } ] }]}

Nitin Sontakke · Answer

Try this. private void button1_Click( object sender EventArgs e) { String jsonString = {\cols\: [{\id\: \A\ \label\: \ 	ype\: 
umber\ \pattern\: \General\ }{ \id\: \B\ \label\: \ 	ype\: \string\ } { \id\: \C\ \label\: \ 	ype\: \string\ } { \id\: \D\ \label\: \ 	ype\: \string\ }{ \id\: \E\ \label\: \ 	ype\: \string\ }] ows\: [{\c\: [{\v\: 1.0\f\: \1\}{\v\: \P24329\}{\v\: \KMHCT41B1FU652568\}{\v\: \971564051696\}{\v\: \Saad\}]}{\c\: [{\v\: 2.0\f\: \2\}{\v\: \I79066\}{\v\: \KMHDG4IE1FU108574\}{\v\: \971565187414\}{\v\: \Saad\}]}] } ; columns col = JsonConvert.DeserializeObject (jsonString); } public class columns { public colsData[] cols { get ; set ; } public vfsArray[] rows { get ; set ; } } public class colsData { public String id { get ; set ; } public String label { get ; set ; } public String type { get ; set ; } public String pattern { get ; set ; } } public class vfsArray { public vfs[] c { get ; set ; } } public class vfs { public String v { get ; set ; } public String f { get ; set ; } }

Nitin Sontakke · Answer

You have got an object like any other. Just use . to access properties. Hover a mouse over it in debug mode.

Nitin Sontakke · Answer

I don't think I have changed the format of the json string. All i have done is escaped double quotes with \ because I needed the json string as a literal in C#. Assuming you are getting json in a some variable you don't have to do it. If it has really helped you please accept one of the appropriate replies as an answer.

Joseph Thomas · Answer

Thank you sir..It works but how did you change the format of json string..? Because there is about 5000 entries in data file...when i pass it orginal format it is not working.

Joseph Thomas · Answer

how to get values from 'col'?