Add custom name to an array using JSON.NET

Question

I need to retrive the array of JSON object like this:

{ "MyCustomName": [ { "id": 0, "item": "item 0" }, { "id": 1, "item": "item 1" } ] }

instead of this:

{ [ { "id": 0, "item": "item 0" }, { "id": 1, "item": "item 1" } ] }

Here is the code i've use:

    using (SqlConnection con = conection.Conect())
            {
                using (SqlCommand cmd = new SqlCommand("SelPeople", con))
                {
                    con.Open();
                    cmd.CommandType = CommandType.StoredProcedure;
                    using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
                    {
                        DataTable dt = new DataTable("MyCustomName");  
                        sda.Fill(dt);
                        List<Personal> ListOfPeople= new List<Personal>();

                        foreach (DataRow dr in dt.Rows)
                        {
                            Personal persona = new Personal();

                            persona.Id = Convert.ToInt32(dr["Id"].ToString());
                        persona.Name = dr["Name"].ToString();
                        //add one row to the list
                        ListOfPeople.Add(persona);
                    }

                   JsonConvert.SerializeObject(ListOfPeople, Formatting.Indented);
                    Response.Write(json);
                }
            }
        }

Some help would be nice, thanks :)

Community · Accepted Answer · 2017-05-23 12:21:43Z

3

Look at this post from another user

In your controller change this part

JsonConvert.SerializeObject(ListOfPeople, Formatting.Indented);
Response.Write(json);

To:

string json = JsonConvert.SerializeObject(new
{
    MyCustomName = ListadoDePersonal;
});
Response.Write(json);

edited May 23, 2017 at 12:21

CommunityBot

11 silver badge

answered Jul 21, 2015 at 2:29

code

1,1378 silver badges14 bronze badges

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

Collectives™ on Stack Overflow

Add custom name to an array using JSON.NET

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related