JSON格式不被支持highchart [英] JSON format is not supported by highchart
本文介绍了JSON格式不被支持highchart的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我用下面的code创建一个JSON文件
I am creating a JSON file using the following code
StringBuilder str = new StringBuilder();
SqlConnection con = new SqlConnection("Data Source=INBDQ2WK2LBCD2S\\SQLEXPRESS;Initial Catalog=MCAS;Integrated Security=SSPI");
SqlDataAdapter adp = new SqlDataAdapter("select top 10 x from test4 order by Id desc", con);
dt = new DataTable();
adp.Fill(dt);
DATA = JsonConvert.SerializeObject(dt, new Newtonsoft.Json.Formatting());
Response.Write(DATA);
我的JSON看起来像
My JSON looks like
[{"x":"58770"},{"x":"79035"},{"x":"84030"},{"x":"90145"},{"x":"95630"},{"x":"102580"},{"x":"108950"},{"x":"113615"},{"x":"118765"},{"x":"124055"}]
不过,我想是这样,
But I want something like,
[[58770,79035,84030,90145,95630,102580...]]
我如何做到这一点,
How do I achieve this,
我想这个特定的格式使用此JSON用于highchart
I want this specific format for using this json for highchart
推荐答案
可以做到这一点在客户端是这样的:
You can achieve that on client side this way:
var d = [{"x":"58770"},{"x":"79035"},{"x":"84030"},{"x":"90145"},{"x":"95630"},{"x":"102580"},{"x":"108950"},{"x":"113615"},{"x":"118765"},{"x":"124055"}],
dLen = d.length,
ret = [];
for(var i = 0; i < dLen; i++) {
ret.push( parseInt(d[i].x, 10));
}
// ret contains: [58770, 79035, 84030, 90145, 95630, 102580, 108950, 113615, 118765, 124055]
这篇关于JSON格式不被支持highchart的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文