How do I take values from html page and insert into sql table?

Question

I want to take all values from this link http://economictimes.indiatimes.com/indices/nifty_50_companies.cms

and want to put those NIFTY 50 companies companyname and LTP into sql table.

please help me give me some threads

I want use c# ,asp.net :)

score 2 · Answer 1 · edited May 23 '17 at 11:52

2

Use HTML Agility Pack to get the values from the HTML page.

Find tutorials from here on how to use HTML Agility Pack.

edited May 23 '17 at 11:52

Community

1
1

answered Jan 20 '12 at 10:23

Bibhu

4,053
4
33
63

score 0 · Answer 2 · answered Jan 20 '12 at 10:26

0

Assuming you already have a table in SQL..

You may do it like this:

Download the page
Parse its content
Bulk Insert the values in the table

answered Jan 20 '12 at 10:26

aF.

64,980
43
135
198

score 0 · Accepted Answer · answered Jan 20 '12 at 11:14

Searcharoo has a class called the HtmlDocument. You can split the downloaded html content(use System.Net.WebClient to download the document from the url) into metatitle, metadescription, metakeywords and content(words).

You can find the searcharoo download here(it is open source)

http://www.searcharoo.net/SearcharooV7/

How do I take values from html page and insert into sql table?

3 Answers3