How to return this format this JSON into an array of strings

Question

I am executing a linq query which gets me all the records from a table:

var data = _context.People.ToList(); //_context is my DataContext.

The above returns the the value:

{ "name": "john", "age": "30" }, { "name": "jane", "age": "31" }

but according to jsonlint, this is invalid and I need to have it be returned as:

[{ "name": "john", "age": "30" }, { "name": "jane", "age": "31" }]

How can I do this?

 viewData.xldata = [];
         $.each(data, function(i, row) {
            var strRow = JSON.stringify(row);
            viewData.xldata.push(strRow);});

Deserialize using `JavaScriptSerializer:

var people = jss.Deserialize<List<People>>(args["xldata"]);

@BhushanFirake - I have a script where I loop through each row and stringify it. I updated the post. — Xaisoft
– Xaisoft, Commented Jun 11, 2013 at 15:18
use JSON.stringify(data); in your code directly, no need of loop — Bhushan Firake
– Bhushan Firake, Commented Jun 11, 2013 at 15:22
Oh. I thought you were trying to generate a json-valid string in server side code, not javascript, oops. — neminem
– neminem, Commented Jun 11, 2013 at 15:22
@BhushanFirake - I did that and that put the [] around the string, but now I get the error message: Type 'JsonDictionaryObject' is not supported for deserialization of an array. in the line: ` public JsonDictionaryObject(string JsonString) : base(jss.Deserialize<JsonDictionaryObject>(JsonString)) { }` — Xaisoft
– Xaisoft, Commented Jun 11, 2013 at 15:41

Ani · Accepted Answer · 2013-06-11 16:18:59Z

1

Try this:

    List<People> data= _context.People.ToList();

   System.Web.Script.Serialization.JavaScriptSerializer objSerializer = default(System.Web.Script.Serialization.JavaScriptSerializer);
   objSerializer = new System.Web.Script.Serialization.JavaScriptSerializer();

    return objSerializer.Serialize(data);

edited Jun 11, 2013 at 16:18

answered Jun 11, 2013 at 16:04

Ani

4,5434 gold badges28 silver badges32 bronze badges

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

Collectives™ on Stack Overflow

How to return this format this JSON into an array of strings

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related