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'?