How to get Json array format as below

{

"Status": 1,

"message": "",

"CityList": [{

"CityId": "1",

"CityName": "Rajkot",

"AreaList": [{

"AreaId": "1",

"AreaName": "Airport Road"

}, {

"AreaId": "2",

"AreaName": "Bus Stand"

}]

}, {

"CityId": "2",

"CityName": "Ahmedabad",

"AreaList": [{

"AreaId": "1",

"AreaName": "Airport Road"

}, {

"AreaId": "2",

"AreaName": "Bus Stand"

}]

}

--------------------------------------------

I have DataTable of city and Area, how can i do the code to get as above formate,

---------------------------------

DataSet dsCS = Objbl.Fill_Grid("GetCountryandState", new string[] //Objbl.Fill_Grid("GetArea", new string[]

{

"View"

});

this.Context.Response.ContentType = "application/json; charset=utf-8";

this.Context.Response.Write(GetJSON(dsCS));

-------------------------------------------------------------------------------

public string GetJSON(DataSet ds)

{

System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();

ArrayList root = new ArrayList();

List> table;

Dictionary data;

foreach (DataTable dt in ds.Tables)

{

table = new List>();

foreach (DataRow dr in dt.Rows)

{

data = new Dictionary();

foreach (DataColumn col in dt.Columns)

{

data.Add(col.ColumnName, dr[col]);

}

table.Add(data);

}

root.Add(table);

}

return serializer.Serialize(root);

}

-----------------------------------------------------------------------------

I am using this code but unable to get the above format. So please help me

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Nitin Sontakke8y ago
You will need a class structure as demonstrated below. You will need to populate it with data first and the serialize it as json.
public class SomeClass
{
  public Int32 Status { get; set; }

  public String Message { get; set; }

  public List CityList { get; set; }

  public SomeClass()
  {
    CityList = new List();
  }
}

public class City
{
  public String CityId { get; set; }

  public String CityName { get; set; }

  public List AreaList { get; set; }

  public City()
  {
    AreaList = new List();
  }
}

public class Area
{
  public String AreaId { get; set; }

  public String AreaName { get; set; }
}