SQL Data to specified JSon Format

Alfaromeo

New member
Joined
Apr 16, 2014
Messages
1
Programming Experience
1-3
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.
 
Top Bottom