JSON Parsing

Muralidhar V

Hi,

I have Json string format like this

{"result":[{"result1":{"row":[{"fld_name":"CityName","fld_caption":"CityName","data_type":"c","modeofentry":"accept"},{"fld_name":"Country","fld_caption":"Country","data_type":"c","modeofentry":"accept"},{"fld_name":"Pincode","fld_caption":"Pincode","data_type":"c","modeofentry":"accept"}]}}]}

Please help me to parse this string and put it in an array or list in c# windows forms aoolication. Please very urgent.

Thanks in advance.

4 Replies

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

Amitesh Verma11y ago
Accepted answer
string baseurl = "URL LINK";

using (WebClient client = new WebClient())
{
string json = client.DownloadString(baseurl );
WeatherInfo weatherInfo = (new JavaScriptSerializer()).Deserialize(json);
int i = weatherInfo.list.Count();
DataTable dt = new DataTable();
dt.Columns.Add("name", typeof(String));
dt.Columns.Add("temp-°?", typeof(Double));
dt.Columns.Add("lat", typeof(Double));
dt.Columns.Add("long", typeof(Double));
for (int a = 0; a < i; a++)
{
dt.Rows.Add(weatherInfo.list[a].name, Math.Round(Convert.ToDouble(weatherInfo.list[a].main.temp) - 273.15, 2), weatherInfo.list[a].coord.lat, weatherInfo.list[a].coord.lon);
}

Its in datatable,use this anywhere,
URL is the url of the json message
Muralidhar V8y ago
Thanks Guys
Debendra Dash11y ago
please use this online site to parse your json data

http://json.parser.online.fr/
Raja T11y ago
Hi Muralidhar,

Try bellow code

using Newtonsoft.Json.Linq;

private void JsonParser_Load(object sender, EventArgs e)
{
List listarr = new List();
string jstr = "{\"result\":[{\"result1\":{\"row\":[{\"fld_name\":\"CityName\",\"fld_caption\":\"CityName\",\"data_type\":\"c\",\"modeofentry\":\"accept\"},{\"fld_name\":\"Country\",\"fld_caption\":\"Country\",\"data_type\":\"c\",\"modeofentry\":\"accept\"},{\"fld_name\":\"Pincode\",\"fld_caption\":\"Pincode\",\"data_type\":\"c\",\"modeofentry\":\"accept\"}]}}]}";

JObject IndeedResume = JObject.Parse(jstr);
listarr.Add(IndeedResume["result"].ElementAt(0)["result1"]["row"].ElementAt(0)["fld_name"].ToString()); //CityName
listarr.Add(IndeedResume["result"].ElementAt(0)["result1"]["row"].ElementAt(0)["fld_caption"].ToString());//CityName
listarr.Add(IndeedResume["result"].ElementAt(0)["result1"]["row"].ElementAt(0)["data_type"].ToString());//c
listarr.Add(IndeedResume["result"].ElementAt(0)["result1"]["row"].ElementAt(0)["modeofentry"].ToString());
listarr.Add(IndeedResume["result"].ElementAt(0)["result1"]["row"].ElementAt(1)["fld_name"].ToString());
listarr.Add(IndeedResume["result"].ElementAt(0)["result1"]["row"].ElementAt(1)["fld_caption"].ToString());
listarr.Add(IndeedResume["result"].ElementAt(0)["result1"]["row"].ElementAt(1)["data_type"].ToString());
listarr.Add(IndeedResume["result"].ElementAt(0)["result1"]["row"].ElementAt(1)["modeofentry"].ToString());
listarr.Add(IndeedResume["result"].ElementAt(0)["result1"]["row"].ElementAt(2)["fld_name"].ToString());
listarr.Add(IndeedResume["result"].ElementAt(0)["result1"]["row"].ElementAt(2)["fld_caption"].ToString());
listarr.Add(IndeedResume["result"].ElementAt(0)["result1"]["row"].ElementAt(2)["data_type"].ToString());
listarr.Add(IndeedResume["result"].ElementAt(0)["result1"]["row"].ElementAt(2)["modeofentry"].ToString());
MessageBox.Show(listarr.Count.ToString());
}