Convert <table> from HTML text file to datatable

I'm just wondering if anyone have come across a code that reads an html
file,search for <table> tag and convert its contents into a datatable and
save it into a dataset.If there are few html tables,then each will be
converted into a datatable and added into the same dataset.

thanks.

Sahil
Wed Oct 20 22:05:19 CDT 2004

Unless the html isn't pure XHTML, you won't find code to do this conversion.

If it indeed is pure XHTML, then you don't need code, you just need to
specify an XSD, and read in the XML (Which is your table HTML), and bingo
you have datatables.

- Sahil Malik
You can reach me thru my blog http://www.dotnetjunkies.com/weblog/sahilmalik


"js" <js@noemail.com> wrote in message
news:u0EUswwtEHA.348@tk2msftngp13.phx.gbl...
> I'm just wondering if anyone have come across a code that reads an html
> file,search for <table> tag and convert its contents into a datatable and
> save it into a dataset.If there are few html tables,then each will be
> converted into a datatable and added into the same dataset.
>
> thanks.
>

Scott
Wed Oct 20 22:05:28 CDT 2004

No. An HTML table is not the same thing as a .NET DataTable (apples and
oranges).

HTML tables don't support any database features (datatypes, length
restrictions, etc.)


"js" <js@noemail.com> wrote in message
news:u0EUswwtEHA.348@tk2msftngp13.phx.gbl...
> I'm just wondering if anyone have come across a code that reads an html
> file,search for <table> tag and convert its contents into a datatable and
> save it into a dataset.If there are few html tables,then each will be
> converted into a datatable and added into the same dataset.
>
> thanks.
>

js
Thu Oct 21 18:35:03 CDT 2004

ok,thanks...i'll write the code myself. I need the code to extract data from
our legacy reporting website.

"Sahil Malik" <contactmethrumyblog@nospam.com> wrote in message
news:e6x0MrxtEHA.2128@TK2MSFTNGP11.phx.gbl...
> Unless the html isn't pure XHTML, you won't find code to do this
conversion.
>
> If it indeed is pure XHTML, then you don't need code, you just need to
> specify an XSD, and read in the XML (Which is your table HTML), and bingo
> you have datatables.
>
> - Sahil Malik
> You can reach me thru my blog
http://www.dotnetjunkies.com/weblog/sahilmalik

Sahil
Fri Oct 22 10:03:32 CDT 2004

Dude, I just had a brainwave in the shower this morning.

You could do a Web Query from Excel, and then you could export that easily
to a data table. You can even write a macro to do this. :)

- Sahil Malik
http://www.dotnetjunkies.com/weblog/sahilmalik



"js" <js@nospam.com> wrote in message
news:%23AvYxb8tEHA.3860@TK2MSFTNGP09.phx.gbl...
> ok,thanks...i'll write the code myself. I need the code to extract data
from
> our legacy reporting website.
>
> "Sahil Malik" <contactmethrumyblog@nospam.com> wrote in message
> news:e6x0MrxtEHA.2128@TK2MSFTNGP11.phx.gbl...
> > Unless the html isn't pure XHTML, you won't find code to do this
> conversion.
> >
> > If it indeed is pure XHTML, then you don't need code, you just need to
> > specify an XSD, and read in the XML (Which is your table HTML), and
bingo
> > you have datatables.
> >
> > - Sahil Malik
> > You can reach me thru my blog
> http://www.dotnetjunkies.com/weblog/sahilmalik
>
>