SQL Data to specified JSon Format

[Alfaromeo]

LIST Time Status
A 22:05 0
B 22:10 1
C 22:30 1
A 22:40 0
C 22:50 1
B 22:60 1 The above table needs to be converted to below JSON format

[

{ "name": "A",
data: [ [22:05,0],
[22:40,0]
]
},
{ "name": "B",
data: [ [22:10,1],
[22:60,1]
]
}
{ "name": "C",
data: [ [22:30,1],
[22:50,1]
]
}
] The above is in a DataTable , now need to format the JSON,the below code does not give me in the same format.

 

[jmcilhinney]

You probably ought to use a a library specifically built for working with JSON.

https://www.google.com.au/search?q=...hannel=sb&gfe_rd=cr&ei=hndPU5nqGceN8Qfz44DgDg