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

Dipika Shah

13y10.4kVisual Basic .NET

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

14 Replies

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

Dipika Shah13y ago
ok..thank u..
Iftikar Hussain13y ago
Add reference of System.Web.Extensions

Regards,
Iftikar
Sanjeeb Lenka13y ago
1. Change the target to dot.net 4 instead of Client Profile
2. Add a reference to System.Web.Extensions (4.0)
3. Got access to JavaScriptSerializer
using System.Web.Script.Serialization;
Dipika Shah13y ago
which dll file use for JavaScriptSerializer
Dipika Shah13y ago
which directive i used for JavaScriptSerializer?
instead of
JavaScriptSerializer js = new JavaScriptSerializer();
plz, tell me other directive..
Iftikar Hussain13y ago
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 Hussain13y ago
do you know what is the object is used in source? like the class object i.e. Movie

Regards,
Iftikar
Dipika Shah13y ago
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 Hussain13y ago
can you please share your code?

Regards,
Iftikar
Iftikar Hussain13y ago
try to use object

Regards,
Iftikar
Dipika Shah13y ago
i use .net 3.5 framework.
Iftikar Hussain13y ago
which version of .net you are using? try with object

Regards,
Iftikar
Dipika Shah13y ago
the type or namespace dynamic could not find.
Iftikar Hussain13y ago
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("\t{0} : {1}", keyValue.Name,keyValue.Value);
}
}
}

Regards,
Iftikar