Parsing web page to JSON

Gagan Sikri

I want to parse data from a web page and store it to a JSON file and use it when needed on ASP.NET webform web page. Please tell me how to do that?

For example take this URL: http://www.railyatri.in/time-table/19718-chandigarh-jaipur-intercity-cdg-to-jp

I want to parse name of station, time of arrival and time of departure in JSON file which I can later on use to display on my ASP.NET webform page.

9 Replies

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

Manas Mohapatra11y ago
Hi,

Below link will help you to implement:

https://jamessdixon.wordpress.com/2012/11/20/consuming-json-from-a-c-project/
Gagan Sikri11y ago
Hi Manas

Actually the thing is I have to take input from user which is train number and then send a http get request to this url: http://railenquiry.in/runningstatus/train_number/date
and the stream of data which will be received, I have to store that data in JSON format.

Can you show me a little demo how can I do that just show me by getting only name of stations to JSON.
Manas Mohapatra11y ago
Hi Gagan

Just go through below link and understand what is JSON and where it is used..

http://www.tutorialspoint.com/json/

Secondly if you want to work display in client side then see below code

Code

Customers
Gagan Sikri11y ago
I used a try catch block, its displaying me error message in catch block. Can you show me how can I do it by giving me tutorial for the scenario I explained, actually I have never worked with JSON and data parsing.
Manas Mohapatra11y ago
Hi,

What is the exception you are getting when you are using above code?

Please paste json data what are getting from the URL. Based on json data you need to parse(like I said declare a class with all attributes which are in json data) and display in your website.
Gagan Sikri11y ago
Hi Manas

The code you provided is not working. Let me explain the scenario:
Consider this URL: Click Here
we have a ASP.NET web page and on that page there is a text box and a button. In textbox user will input the train number and we have to parse data from the url mentioned above.
For eg user inputs train number: 19717
then url will be: http://railenquiry.in/runningstatus/19717/2015-07-24

I want to parse the name of stations and time of arrival and departure from data on this website in JSON file which I can later on use to display on my ASP.NET webpage.
Manas Mohapatra11y ago
Hi Gagan,

Whatever code I provided is not working(throwing exception) or it doesn't meet requirement?

Secondly please describe more what you need exactly?
Gagan Sikri11y ago
I am trying this solution you provided, but its not working, can you show me how to do parsing of data from a webpage. Let us take example of this URL.
I simply need to generate a JSON containing station names.
Manas Mohapatra11y ago
Hi Gagan,

As per your requirement please find below steps:

Step 1 :
Declare a station class.

public class Station
{
   public string name { get; set; }
   public DateTime arrival { get; set; }
   public DateTime departure { get; set; }
}

Step 2 :
Add namespace using System.Web.Script.Serialization;
Create a station list. For now I hard coded it but for your case you can retrieve it from database.

List stationList = new List()
{
   new Station() { name = "st1", arrival = DateTime.Now, departure =     DateTime.Now.AddMinutes(10) },
   new Station() { name = "st2", arrival = DateTime.Now, departure =    DateTime.Now.AddMinutes(10) }
};
// Creating serialization object
JavaScriptSerializer serializer = new JavaScriptSerializer();
string test = serializer.Serialize(stationList);

// Writing sesrialization data to json file
System.IO.File.WriteAllText(@"D:\station.json", test);

Step 3 :
Now our data is saved in json file, we will read data from it...

// Read data from json file
string text = System.IO.File.ReadAllText(@"D:\station.json");
List stationListBack = serializer.Deserialize>(text);

// Looping over station list
foreach (var temp in stationListBack)
{
Response.Write(temp.name + " || " + temp.arrival + " " + temp.departure + "
");
}

Parsing web page to JSON

Customers