Can i able to store each item in a json array inside a foreach loop in c# web api?

Question

I want to store each item to a json array which is placed inside a foreach loop.

object array="";
foreach (DataRow drow1 in alltheatre.Rows)
        {
            string theatname = drow1["TheatreName"].ToString();
            string latitude = drow1["Latitude"].ToString();
            string longitude = drow1["Longitude"].ToString();
            string theatname = drow1["TheatreName"].ToString();
            string theatid = drow1["TheatreDetailsId"].ToString();
            string theataddre = drow1["TheatreAddress"].ToString();
            string cntctnu = drow1["ContactNum"].ToString();
            string theatimg = drow1["TheatreImage"].ToString();
            string descr = drow1["TheatreDesc"].ToString();
            string mouvieid = drow1["MovieMasterId"].ToString();
            if (mouvieid <100)
             {
                 array = new[]
                        {
                           new
                            {
                           Name = theatname,
                           Theatrdetailsid=theatid,
                           image=theatimg,
                           lat=latitude,
                           longi=longitude,
                           adress=theataddre,
                           contactnum=cntctnu,
                           desc=descr,
                            }
                          },
                        }
                      }

Here.i have a foreach loop for getting details about a theatre,i want to store these datas to a json array,based on the condition.Right now i can only managed to store 1 data,ie the last one.

BenM · Accepted Answer · 2015-10-17 07:17:28Z

1

The issue is that this code creates a new array with every iteration of the loop. Try something like:

    using Newtonsoft.Json;

    string[] array = new string[]{};
    //data access and loop code
    int id = int.Parse(mouvieId);
    if (id < 100)
    {
        array[id] = JsonConvert.SerializeObject(new { Name = theatname /*rest of properties*/ });
    }

edited Oct 17, 2015 at 7:17

answered Oct 17, 2015 at 6:29

BenM

1217 bronze badges

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

Comments

Amit Gupta · Accepted Answer · 2015-10-19 07:58:13Z

0

If the datagrid row object is of strongly typed then you can covert the rows collection to enumerable strongly typed. Over the collection you can use Linq query to filter those records which matches the desired condition and in Select clause you can serialize the object using JsonCovert.SerializeObject method (from Newton.Json assembly).

For ex :
List theatres = alltheatre.Rows as List;
var serializedTheatres = theares.Where(t => t.MouvieId > 100).Select(t => JsonCovert.SerializeObject(t)).ToList();

edited Oct 19, 2015 at 7:58

answered Oct 17, 2015 at 9:20

Amit Gupta

238 bronze badges

Collectives™ on Stack Overflow

Can i able to store each item in a json array inside a foreach loop in c# web api?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related