Json deserialising.

Joseph Thomas

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"

}

]

}]}

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nitin Sontakke9y ago
Accepted answer
Try this.
  private void button1_Click(object sender, EventArgs e)
  {
    String jsonString = "{\"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\"}]}] }";
    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 Sontakke9y ago
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 Thomas9y ago
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.
Nitin Sontakke9y ago
You have got an object like any other. Just use . to access properties. Hover a mouse over it in debug mode.
Joseph Thomas9y ago
how to get values from 'col'?