HTML Data

Question

HTML Data

sudhakara

SSCrazy Eights

Points: 9425
More actions
May 28, 2010 at 7:19 am

#141257

Hi,
I want read the data from the online html page using my application user name and password
and update into sql server tables.
is there any way to accomplish this task in sql server ? Please update your suggestion and comments to accomplish task.
Thanks in Advance.

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323546 More actions · Answer 1

wrong tool for the job.

reading a web page, entering username and password /submit and browsing to other pages requires some interaction type activities.

much much better to create an application in .NET to do that, and store the resulting pages in SQL server, instead of trying to do it all from SQL.

no matter what, you have to use resources outside of SQL, so do all the work outside of SQL where it is much easier to do it in the first place.

For example, if you take a look at WaTiN(Web ApplicaitonTesting In .NET), you can use that to open a page, goto a link, have it type in a username and password or fill out any kind of <form> on a web page, do the submit, and have the page.html around for parsing.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!