JSON Parsing

Question

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.

Amitesh Verma · 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 { 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 V · Answer

Thanks Guys

Debendra Dash · Answer

please use this online site to parse your json data http://json.parser.online.fr/

Raja T · Answer

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()); }