To get the data from the list into JSON format

Question

Below is my code to get the JSON data,

for (int k = 0; k < 4; k++)
{
  List<HMData> Data_Content = new List<HMData>();
   for (int l = 0; l < 7; l++)
    {  
      Value_LfromList = LValues.ElementAt((k * 7) + l);
      Value_IfromList = IValues.ElementAt((k * 7) + l);
      Value_BfromList = BValues.ElementAt((k * 7) + l);
       Data_Content.Add(new HMData { x = Value_LfromList, y = Value_IfromList, z = Value_BfromList });
     }
     data_list.Add(Data_Content);
  } 
  var chart = new
        {
            type = ChartType
        };
   var data = new { data=data_list };
   var series = new[] { data };
   var obj = new {chart,series};
   string result = jSearializer.Serialize(obj);

Output I get is as follows,

{"chart":{"type":"bubble"},
 "series":
  [{"data":
    [
       [{"x":7,"y":7,"z":49},{"x":7,"y":7,"z":49},{"x":7,"y":9,"z":63},{"x":5,"y":9,"z":45},{"x":4,"y":3,"z":12},{"x":2,"y":6,"z":12},{"x":3,"y":5,"z":15}],
       [{"x":7,"y":8,"z":56},{"x":7,"y":8,"z":56},{"x":7,"y":8,"z":56},{"x":9,"y":6,"z":54},{"x":5,"y":7,"z":35},{"x":3,"y":8,"z":24},{"x":4,"y":3,"z":12}],
       [{"x":7,"y":8,"z":56},{"x":7,"y":8,"z":56},{"x":7,"y":8,"z":56},{"x":8,"y":7,"z":56},{"x":5,"y":7,"z":35},{"x":3,"y":7,"z":21},{"x":5,"y":8,"z":40}],
       [{"x":3,"y":7,"z":21},{"x":3,"y":7,"z":21},{"x":5,"y":2,"z":10},{"x":5,"y":2,"z":10},{"x":8,"y":6,"z":48},{"x":7,"y":3,"z":21},{"x":6,"y":7,"z":42}]
    ]}
  ]
 }

but I want the output as follows,

{"chart":{"type":"bubble"},
 "series":
  [{"data":[{"x":7,"y":7,"z":49},{"x":7,"y":7,"z":49},{"x":7,"y":9,"z":63},{"x":5,"y":9,"z":45},{"x":4,"y":3,"z":12},{"x":2,"y":6,"z":12},{"x":3,"y":5,"z":15}],

    "data":[{"x":7,"y":8,"z":56},{"x":7,"y":8,"z":56},{"x":7,"y":8,"z":56},{"x":9,"y":6,"z":54},{"x":5,"y":7,"z":35},{"x":3,"y":8,"z":24},{"x":4,"y":3,"z":12}],

    "data":[{"x":7,"y":8,"z":56},{"x":7,"y":8,"z":56},{"x":7,"y":8,"z":56},{"x":8,"y":7,"z":56},{"x":5,"y":7,"z":35},{"x":3,"y":7,"z":21},{"x":5,"y":8,"z":40}],

    "data":[{"x":3,"y":7,"z":21},{"x":3,"y":7,"z":21},{"x":5,"y":2,"z":10},{"x":5,"y":2,"z":10},{"x":8,"y":6,"z":48},{"x":7,"y":3,"z":21},{"x":6,"y":7,"z":42}]
    }
  ]
 }

Any Idea how it can be achieved...????

--------Updated question------

for (int k = 0; k < 4; k++)
{
  List<HMData> Data_Content = new List<HMData>();
   for (int l = 0; l < 7; l++)
    {  
      Value_LfromList = LValues.ElementAt((k * 7) + l);
      Value_IfromList = IValues.ElementAt((k * 7) + l);
      Value_BfromList = BValues.ElementAt((k * 7) + l);
       Data_Content.Add(new HMData { x = Value_LfromList, y = Value_IfromList, z = Value_BfromList });
     }
     data_list.Add(Data_Content);
  } 
  var chart = new
        {
            type = ChartType
        };
   var data = new { data=data_list.ToArray() };
   var series = new[] { data };
   var obj = new {chart,series};
   string result = jSearializer.Serialize(obj);

but output I am getting is still the same,as follows,

{"chart":{"type":"bubble"},"series":[{"data":[[{"x":7,"y":7,"z":49},
{"x":7,"y":7,"z":49},{"x":7,"y":9,"z":63},{"x":5,"y":9,"z":45},{"x":4,"y":3,"z":12},
{"x":2,"y":6,"z":12},{"x":3,"y":5,"z":15}],[{"x":7,"y":8,"z":56},{"x":7,"y":8,"z":56},
{"x":7,"y":8,"z":56},{"x":9,"y":6,"z":54},{"x":5,"y":7,"z":35},{"x":3,"y":8,"z":24},
{"x":4,"y":3,"z":12}],[{"x":7,"y":8,"z":56},{"x":7,"y":8,"z":56},{"x":7,"y":8,"z":56},
{"x":8,"y":7,"z":56},{"x":5,"y":7,"z":35},{"x":3,"y":7,"z":21},{"x":5,"y":8,"z":40}],
[{"x":3,"y":7,"z":21},{"x":3,"y":7,"z":21},{"x":5,"y":2,"z":10},{"x":5,"y":2,"z":10},
{"x":8,"y":6,"z":48},{"x":7,"y":3,"z":21},{"x":6,"y":7,"z":42}]]}]}

have you tried to declare data as an array instead of a list? — Behrad Farsi
– Behrad Farsi, Commented Jan 6, 2014 at 13:27
Which list you are talking about...?...data_list or var data..??? — Reshma
– Reshma, Commented Jan 6, 2014 at 13:29
but then I get error since I am not able to add the data_content list value to array of data..can you show me how can I assign values to array,it will be very grateful of you — Reshma
– Reshma, Commented Jan 6, 2014 at 13:38
you can convert it to array: var data = new { data=data_list.ToArray() } — Behrad Farsi
– Behrad Farsi, Commented Jan 6, 2014 at 13:42
if you mean to say that I should define var data in above code the way you have given but still I cannot get desired output, — Reshma
– Reshma, Commented Jan 6, 2014 at 13:48

nestedloop · Accepted Answer · 2014-01-07 16:14:28Z

1

Try this:

System.Collections.Generic.List<object> dataList = new System.Collections.Generic.List<object>();
for (int k = 0; k < 4; k++)
        {
            List<HMData> Data_Content = new List<HMData>();
            for (int l = 0; l < 7; l++)
            {

                Value_LfromList = LValues.ElementAt((k * 7) + l);
                Value_IfromList = IValues.ElementAt((k * 7) + l);
                Value_BfromList = BValues.ElementAt((k * 7) + l);
                Data_Content.Add(new HMData { x = Value_LfromList, y = Value_IfromList, z = Value_BfromList });
            }
            dataList.Add(new {data = Data_Content});
        } 
  var chart = new
        {
            type = ChartType
        };
var series = dataList;
var obj = new { chart, series };
string result = jSearializer.Serialize(obj);

answered Jan 7, 2014 at 16:14

nestedloop

2,67624 silver badges35 bronze badges

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

Collectives™ on Stack Overflow

To get the data from the list into JSON format

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