这是从数据库取出的数据,现在想变为这种json格式,请问用什么方法比较合适?
从数据库获取数据是通过ashx实现的
var data1 = [{
text: "p1",
nodes: [
{
"text": "A", "id": "1", "nodes": [
{"text": "A1","id": "4"},
{"text": "A2","id": "5"},
{"text": "A3","id": "6"}
]
},
{
"text": "B","id": "2","nodes": [
{"text": "B1","id": "7"},
{"text": "B2", "id": "9"}
]
},
{
"text": "C","id": "11","nodes": [
{"text": "C1","id": "8","nodes": [
{"text": "C2","id": "10"}
]
}
]
},
{"text": "p1-1","id": "00001"},
{"text": "p1-2","id": "00002"},
{"text": "p1-3","id": "00003"},
{
"text": "p1-4", "id": "00004", "nodes": [
{"text": "p1-1-1","id": "00005"},
{"text": "p1-1-2","id": "00005"}
]
}
] }]
从数据库获取数据是通过ashx实现的
var data1 = [{
text: "p1",
nodes: [
{
"text": "A", "id": "1", "nodes": [
{"text": "A1","id": "4"},
{"text": "A2","id": "5"},
{"text": "A3","id": "6"}
]
},
{
"text": "B","id": "2","nodes": [
{"text": "B1","id": "7"},
{"text": "B2", "id": "9"}
]
},
{
"text": "C","id": "11","nodes": [
{"text": "C1","id": "8","nodes": [
{"text": "C2","id": "10"}
]
}
]
},
{"text": "p1-1","id": "00001"},
{"text": "p1-2","id": "00002"},
{"text": "p1-3","id": "00003"},
{
"text": "p1-4", "id": "00004", "nodes": [
{"text": "p1-1-1","id": "00005"},
{"text": "p1-1-2","id": "00005"}
]
}
] }]
循环datatable,来个递归什么的,组合成json对象