Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 220
  • Last Modified:

Extracting Data from tables on HTML pages

I'm trying to write a sports betting application that will spider websites to get the upcoming fixtures and previous form and then apply various selection criteria to the data.  The data is found mainly in HTML table cells.  How do I write code to loop through all the rows in all of the tables in a HTML page and extract the rows and treat them as individual records, and then extract the data from the cells and treat them as the record fields?  I just want to extract each row so that I can stick the data into a database.

This is done in VB.Net.

Thanks
0
useless_eater
Asked:
useless_eater
1 Solution
 
Kinger247Commented:
The trouble you have is that although this could be done, it may not be the best way.

For example, you could add the webbrowser control to a form and load a web page. Then loop through the elements on the document (html page), locate the tags your looking for that contain the data you need.

BUT, these pages are bound to be asp type pages and prone to change. Then your back to square one again.
This WILL happen frequently !

It sounds like your looking for a shortcut, but your not going to get it so easliy.

I was asked to a do a smiliar thing with energy proces, in the end I gave up.

You could search for some sites that offer web services ?
Could be your only possible solution.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now