JSON format is not supported by highchart

Question

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);

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,

I want this specific format for using this json for highchart

What are you selecting from the database? – शेखर Nov 29 '13 at 11:39 — शेखर, Nov 29 '13 at 11:39
I am selecting single column and last 10 data from it – SPandya Nov 29 '13 at 11:43 — SPandya, Nov 29 '13 at 11:43

score 2 · Accepted Answer · answered Nov 29 '13 at 11:47

2

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]

answered Nov 29 '13 at 11:47

Paweł Fus

44,795
3
61
77

and how do I get this JSON at client side? – SPandya Nov 29 '13 at 11:48
Check some other similar questions, like [this one](http://stackoverflow.com/questions/16441880/how-to-return-json-object). – Paweł Fus Nov 29 '13 at 12:49

JSON format is not supported by highchart

1 Answers1