how to extract json data in c#.net windows form application?

Question

i have following json data:

{"Movies":[{"Movie":

{"id":"21",

"name":"BombayTalkies",

"image":"http:\/\/projects.device-developer.com\/gettickets\/img\/uploads\/movie\/original\/1367224274168.jpg",

"screen":"screen3",

"time":"2013-07-20 15:00:00"

}

},

{"Movie":

{"id":"91",

"name":"Aashiqui 2",

"image":"http:\/\/projects.device-developer.com\/gettickets\/img\/uploads\/movie\/original\/1367218928839.png",

"screen":"screen2",

"time":"2013-07-20 18:00:00"

}

} ] }
how to select above data? i want to extract data in label like
id moviename movieimage screen time
91 Aashiqui2 picturebox screen2 2013-07-20 18:00:00
img aashiqui

Dipika Shah · Answer

ok..thank u..

Iftikar Hussain · Answer

Add reference of System.Web.Extensions Regards, Iftikar

Sanjeeb Lenka · Answer

Change the target to dot.net 4 instead of Client Profile Add a reference to System.Web.Extensions (4.0) Got access to JavaScriptSerializer using System.Web.Script.Serialization;

Dipika Shah · Answer

which dll file use for JavaScriptSerializer

Dipika Shah · Answer

which directive i used for JavaScriptSerializer? instead of JavaScriptSerializer js = new JavaScriptSerializer(); plz, tell me other directive..

Iftikar Hussain · Answer

First you need an object public class MyObject { public string Id {get;set;} public string Text {get;set;} ... } Then in here using (var twitpicResponse = (HttpWebResponse)request.GetResponse()) { using (var reader = new StreamReader(twitpicResponse.GetResponseStream())) { JavaScriptSerializer js = new JavaScriptSerializer(); var objText = reader.ReadToEnd(); MyObject myojb = (MyObject)js.Deserialize(objText,typeof(MyObject)); } } Regards, Iftikar

Iftikar Hussain · Answer

do you know what is the object is used in source? like the class object i.e. Movie Regards, Iftikar

Dipika Shah · Answer

my API code is: HttpWebRequest httpWReq1 = (HttpWebRequest)WebRequest.Create("http://projects.device-developer.com/gettickets/api/Shows/getmovies.json"); ASCIIEncoding encoding1 = new ASCIIEncoding(); string postData1; postData1 = "apikey=51"; postData1 += "&password=i41AtRcqbWCDeMd5vXNws2f9oLmnE"; postData1 += "&multiplex_id=51"; byte[] data1 = encoding1.GetBytes(postData1); httpWReq1.Method = "POST"; httpWReq1.ContentType = "application/x-www-form-urlencoded"; //httpWReq1.ContentType = "application/json"; httpWReq1.ContentLength = data1.Length; using (Stream stream = httpWReq1.GetRequestStream()) { stream.Write(data1, 0, data1.Length); } HttpWebResponse response1 = (HttpWebResponse)httpWReq1.GetResponse(); string responseString1 = new StreamReader(response1.GetResponseStream()).ReadToEnd(); label_data_api.Text = responseString1; using this encoding i got following data in my label {"Movies":[{"Movie": {"id":"21", "name":"BombayTalkies", "image":"http:\/\/projects.device-developer.com\/gettickets\/img\/uploads\/movie\/original\/1367224274168.jpg", "screen":"screen3", "time":"2013-07-20 15:00:00" } }, {"Movie": {"id":"91", "name":"Aashiqui 2", "image":"http:\/\/projects.device-developer.com\/gettickets\/img\/uploads\/movie\/original\/1367218928839.png", "screen":"screen2", "time":"2013-07-20 18:00:00" } } ] } now i convert this data in follwing way: id moviename movieimage screen time 91 Aashiqui2 picturebox screen2 2013-07-20 18:00:00 img aashiqui so, how to get data this way?

Iftikar Hussain · Answer

can you please share your code? Regards, Iftikar

Iftikar Hussain · Answer

try to use object Regards, Iftikar

Dipika Shah · Answer

i use .net 3.5 framework.

Iftikar Hussain · Answer

which version of .net you are using? try with object Regards, Iftikar

Dipika Shah · Answer

the type or namespace dynamic could not find.

Iftikar Hussain · Answer

Hi, Try like this dynamic dynObj = JsonConvert.DeserializeObject(json); foreach(var data in dynObj.Root.data) { Console.WriteLine("{0}",data.name); foreach(var fql in data.fql_result_set) { foreach (JProperty keyValue in fql) { Console.WriteLine("	{0} : {1}", keyValue.Name,keyValue.Value); } } } Regards, Iftikar

how to extract json data in c#.net windows form application?

Answers (14)