json生成 - 专家坐堂 - Foxtable(狐表) - 新一代数据库软件，完美融合Access、Foxpro、Excel、vb.net之优势，人人都能掌握的快速软件开发工具!

{

foxtable:[

{name: '北京',value: 20 },

{name: '天津',value: 10 },

{name: '上海',value: 30 },

{name: '重庆',value: 8 },

{name: '河北',value: 5 },

{name: '河南',value: 7 },

{name: '云南',value: 3 },

{name: '辽宁',value: 11 },

{name: '黑龙江',value: 12 },

{name: '湖南',value: 13 },

{name: '安徽',value: 18 },

{name: '山东',value: 20 },

{name: '新疆',value: 10 },

{name: '江苏',value: 11 },

{name: '浙江',value: 25 },

{name: '江西',value: 6 },

{name: '湖北',value: 16 },

{name: '广西',value: 12 },

{name: '甘肃',value: 8 },

{name: '山西',value: 9 },

{name: '内蒙古',value: 10 },

{name: '陕西',value: 11 },

{name: '吉林',value: 12 },

{name: '福建',value: 13 },

{name: '贵州',value: 8 },

{name: '广东',value: 30 },

{name: '青海',value: 10 },

{name: '西藏',value: 5 },

{name: '四川',value: 9 },

{name: '宁夏',value: 10 },

{name: '海南',value: 11 },

{name: '台湾',value: 3 },

{name: '香港',value: 5 },

{name: '澳门',value: 2 }

]

}

今天看了版主在FT里使用百度ＥＣＨＡＲＴＳ图表的例子比较喜欢，但对查询出来的dt

如何生成ＪＳＯＮ看了帮助还是有点不懂，能否基于上面的例子，写一个查询表如何生

成上述ＪＳＯＮ的小例，供我等学习下，谢谢！

foxtable:[ 主要是这里，我看狐表帮助里生成的都带引号　"foxtable:["，这个不影响吗？

这个不影响，js支持这种用法。

生成json方法参考

......

Case "getdata.htm"

Dim json As String

If e.GetValues("type") = "1" Then

json = FileSys.ReadAllText("d:\web\lib\data1.txt")

Else

Dim jo As New JObject

Dim ja As New Jarray '定义数组

Dim arr() As String = {"北京","天津","上海","重庆","河北","河南","云南"}

For Each csh As String In arr

Dim j2 As new JObject

j2("name") = csh

j2("value") = Rand.Next(3,20)

ja.Add(j2)

jo("foxtable") = ja

json = jo.ToString

End If

e.WriteString(json )

......

http://www.foxtable.com/mobilehelp/scr/0167.htm

如果是查表把上面代码的数组和赋值改为从数据库查询的结果就可以了

var data = [

[[28604,77,17096869,'Australia',1990],[31163,77.4,27662440,'Canada',1990],[1516,68,1154605773,'China',1990],[13670,74.7,10582082,'Cuba',1990],[28599,75,4986705,'Finland',1990],[29476,77.1,56943299,'France',1990],[31476,75.4,78958237,'Germany',1990],[28666,78.1,254830,'Iceland',1990],[1777,57.7,870601776,'India',1990],[29550,79.1,122249285,'Japan',1990],[2076,67.9,20194354,'North Korea',1990],[12087,72,42972254,'South Korea',1990],[24021,75.4,3397534,'New Zealand',1990],[43296,76.8,4240375,'Norway',1990],[10088,70.8,38195258,'Poland',1990],[19349,69.6,147568552,'Russia',1990],[10670,67.3,53994605,'Turkey',1990],[26424,75.7,57110117,'United Kingdom',1990],[37062,75.4,252847810,'United States',1990]],

[[44056,81.8,23968973,'Australia',2015],[43294,81.7,35939927,'Canada',2015],[13334,76.9,1376048943,'China',2015],[21291,78.5,11389562,'Cuba',2015],[38923,80.8,5503457,'Finland',2015],[37599,81.9,64395345,'France',2015],[44053,81.1,80688545,'Germany',2015],[42182,82.8,329425,'Iceland',2015],[5903,66.8,1311050527,'India',2015],[36162,83.5,126573481,'Japan',2015],[1390,71.4,25155317,'North Korea',2015],[34644,80.7,50293439,'South Korea',2015],[34186,80.6,4528526,'New Zealand',2015],[64304,81.6,5210967,'Norway',2015],[24787,77.3,38611794,'Poland',2015],[23038,73.13,143456918,'Russia',2015],[19360,76.5,78665830,'Turkey',2015],[38225,81.4,64715810,'United Kingdom',2015],[53354,79.1,321773631,'United States',2015]]

];

那散点图中这样的也是ＪＳＯＮ吗？还是是单纯的数组，要如何生成呢？谢谢

这个是数组，也可以通过json返回，和1楼的用法是一样的。

{

mydata: [

[[28604,77,17096869,'Australia',1990],[31163,77.4,27662440,'Canada',1990],[1516,68,115460........

}

......

var data = json对象.mydata

主题：json生成