Use JSON String in JavaScript

Question

I created a JSON string using JSON.NET.

using following code

  public void JSONTable()
    {
        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,dt from test4 order by Id desc", con);
        DataTable dt = new DataTable();
        adp.Fill(dt);

        string DATA = JsonConvert.SerializeObject(dt, new Newtonsoft.Json.Formatting());

    }

The JSON looks like

[{"x":"0","dt":"11/21/2013 3:07:53 PM"},{"x":"0","dt":"11/21/2013 3:07:52 PM"},{"x":"0","dt":"11/21/2013 3:07:50 PM"},{"x":"0","dt":"11/21/2013 2:47:21 PM"},{"x":"0","dt":"11/21/2013 2:47:20 PM"},{"x":"0","dt":"11/21/2013 2:20:02 PM"},{"x":"188","dt":"11/20/2013 11:46:53 AM"},{"x":"188","dt":"11/13/2013 11:31:38 AM"},{"x":"188","dt":"11/13/2013 11:31:26 AM"},{"x":"188","dt":"10/31/2013 2:49:27 PM"}]

Now how can I use this JSON String DATA into Javascript?

And How can I create a physical file with .json extension?

Well I want to use this for creating either google chart or highchart. — SPandya
– SPandya, Commented Nov 25, 2013 at 10:44
@Enam: It gives the error that` DATA does not exists in the current context` — SPandya
– SPandya, Commented Nov 25, 2013 at 10:47

Enam · Accepted Answer · 2013-11-25 10:55:55Z

1

If you need onload object:

You may create in your code-behind global public string variable with valid JSON:

public string DATA;

After that create js variable to use it in your client code:

var jsDATA = <%= DATA %>;

If your JSON was valid no JSON.Parse is needed.

answered Nov 25, 2013 at 10:55

Enam

1,2581 gold badge9 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

SPandya Over a year ago

Pls see my edited code, it is still showing the error that Data does not exist in current context

Enam Over a year ago

To use variable in .aspx you must declare it as public attribute of your main class (not in local scope in method JSONTable()).

Anatolii Gabuza · Accepted Answer · 2013-11-25 11:09:22Z

1

If you have a json data stored as a string and you want to get an object in JS - use $.parseJSON(yourStringJSON) from jQuery. Another option (I prefer it) is to use JSON.parse(yourStringJSON).
Both methods return json object.

edited Nov 25, 2013 at 11:09

answered Nov 25, 2013 at 10:59

Anatolii Gabuza

6,2902 gold badges39 silver badges54 bronze badges

Collectives™ on Stack Overflow

Use JSON String in JavaScript

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related