Jump to content
Xtreme .Net Talk

HTML Table to VB.Net DataGrid

NID

By NID
in General

 Share

Recommended Posts

NID Newbie

NID

Posted
Posted

Hi everyone I have html table from which somehow I need to read data in to VB.Net DataGrid.

What would be the best solution for me. The HTML Table looks like this:

 

 

<TABLE WIDTH=80% BORDER=0 CELLPADDING=1 CELLSPACING=0>

<THEAD>

<TR BGCOLOR=#ebebff ALIGN=RIGHT>

<TH> </TH>

<TH ALIGN=left><U>Date</U></TH>

<TH> </TH>

<TH><U>Peak quota</U></TH>

<TH><U>Bliinkzone</U></TH>

<TH><U>Bliinktime quota</U></TH>

<TH><U>Total</U></TH>

<TH> </TH>

</TR>

</THEAD>

<TBODY>

<TR BGCOLOR=ffffff ALIGN=right>

<TD> </TD>

<TD ALIGN=left><A HREF=volumegraphs.cgi?action=showday&period=20030713&username=dimae>13-07-2003</A></TD>

<TD> </TD>

<TD>0.00</TD>

<TD>0.00</TD>

<TD>0.00</TD>

<TD>0.00</TD>

<TD> </TD>

</TR>

<TR BGCOLOR=f5f5f5 ALIGN=right>

<TD> </TD>

<TD ALIGN=left><A HREF=volumegraphs.cgi?action=showday&period=20030714&username=dimae>14-07-2003</A></TD>

<TD> </TD>

<TD>0.00</TD>

<TD>0.00</TD>

<TD>0.00</TD>

<TD>0.00</TD>

<TD> </TD>

</TR>

<TR BGCOLOR=ffffff ALIGN=right>

<TD> </TD>

<TD ALIGN=left><A HREF=volumegraphs.cgi?action=showday&period=20030715&username=dimae>15-07-2003</A></TD>

<TD> </TD>

<TD>0.00</TD>

<TD>0.00</TD>

<TD>0.00</TD>

<TD>0.00</TD>

<TD> </TD>

</TR>

<TR BGCOLOR=f5f5f5 ALIGN=right>

<TD> </TD>

<TD ALIGN=left><A HREF=volumegraphs.cgi?action=showday&period=20030716&username=dimae>16-07-2003</A></TD>

<TD> </TD>

<TD>0.00</TD>

<TD>0.00</TD>

<TD>0.00</TD>

<TD>0.00</TD>

<TD> </TD>

</TR>

<TR BGCOLOR=ffffff ALIGN=right>

<TD> </TD>

<TD ALIGN=left><A HREF=volumegraphs.cgi?action=showday&period=20030717&username=dimae>17-07-2003</A></TD>

<TD> </TD>

<TD>0.00</TD>

<TD>0.00</TD>

<TD>0.00</TD>

<TD>0.00</TD>

<TD> </TD>

</TR>

<TR BGCOLOR=f5f5f5 ALIGN=right>

<TD> </TD>

<TD ALIGN=left><A HREF=volumegraphs.cgi?action=showday&period=20030718&username=dimae>18-07-2003</A></TD>

<TD> </TD>

<TD>0.00</TD>

<TD>0.00</TD>

<TD>0.00</TD>

<TD>0.00</TD>

<TD> </TD>

</TR>

<TR BGCOLOR=ffffff ALIGN=right>

<TD> </TD>

<TD ALIGN=left><A HREF=volumegraphs.cgi?action=showday&period=20030719&username=dimae>19-07-2003</A></TD>

<TD> </TD>

<TD>0.00</TD>

<TD>0.00</TD>

<TD>0.00</TD>

<TD>0.00</TD>

<TD> </TD>

</TR>

<TR BGCOLOR=f5f5f5 ALIGN=right>

<TD> </TD>

<TD ALIGN=left><A HREF=volumegraphs.cgi?action=showday&period=20030720&username=dimae>20-07-2003</A></TD>

<TD> </TD>

<TD>0.00</TD>

<TD>0.00</TD>

<TD>0.00</TD>

<TD>0.00</TD>

<TD> </TD>

</TR>

<TR BGCOLOR=ffffff ALIGN=right>

<TD> </TD>

<TD ALIGN=left><A HREF=volumegraphs.cgi?action=showday&period=20030721&username=dimae>21-07-2003</A></TD>

<TD> </TD>

<TD>0.00</TD>

<TD>0.00</TD>

<TD>0.00</TD>

<TD>0.00</TD>

<TD> </TD>

</TR>

<TR BGCOLOR=f5f5f5 ALIGN=right>

<TD> </TD>

<TD ALIGN=left><A HREF=volumegraphs.cgi?action=showday&period=20030722&username=dimae>22-07-2003</A></TD>

<TD> </TD>

<TD>0.00</TD>

<TD>0.00</TD>

<TD>0.00</TD>

<TD>0.00</TD>

<TD> </TD>

</TR>

<TR BGCOLOR=ffffff ALIGN=right>

<TD> </TD>

<TD ALIGN=left><A HREF=volumegraphs.cgi?action=showday&period=20030723&username=dimae>23-07-2003</A></TD>

<TD> </TD>

<TD>0.00</TD>

<TD>0.00</TD>

<TD>0.00</TD>

<TD>0.00</TD>

<TD> </TD>

</TR>

<TR BGCOLOR=f5f5f5 ALIGN=right>

<TD> </TD>

<TD ALIGN=left><A HREF=volumegraphs.cgi?action=showday&period=20030724&username=dimae>24-07-2003</A></TD>

<TD> </TD>

<TD>0.00</TD>

<TD>0.00</TD>

<TD>0.00</TD>

<TD>0.00</TD>

<TD> </TD>

</TR>

<TR BGCOLOR=ffffff ALIGN=right>

<TD> </TD>

<TD ALIGN=left><A HREF=volumegraphs.cgi?action=showday&period=20030725&username=dimae>25-07-2003</A></TD>

<TD> </TD>

<TD>0.00</TD>

<TD>0.00</TD>

<TD>0.00</TD>

<TD>0.00</TD>

<TD> </TD>

</TR>

<TR BGCOLOR=f5f5f5 ALIGN=right>

<TD> </TD>

<TD ALIGN=left><A HREF=volumegraphs.cgi?action=showday&period=20030726&username=dimae>26-07-2003</A></TD>

<TD> </TD>

<TD>13.09</TD>

<TD>0.00</TD>

<TD>0.00</TD>

<TD>13.09</TD>

<TD> </TD>

</TR>

<TR BGCOLOR=ffffff ALIGN=right>

<TD> </TD>

<TD ALIGN=left><A HREF=volumegraphs.cgi?action=showday&period=20030727&username=dimae>27-07-2003</A></TD>

<TD> </TD>

<TD>98.64</TD>

<TD>0.00</TD>

<TD>64.20</TD>

<TD>162.84</TD>

<TD> </TD>

</TR>

<TR BGCOLOR=f5f5f5 ALIGN=right>

<TD> </TD>

<TD ALIGN=left><A HREF=volumegraphs.cgi?action=showday&period=20030728&username=dimae>28-07-2003</A></TD>

<TD> </TD>

<TD>377.28</TD>

<TD>0.00</TD>

<TD>10.42</TD>

<TD>387.70</TD>

<TD> </TD>

</TR>

<TR BGCOLOR=ffffff ALIGN=right>

<TD> </TD>

<TD ALIGN=left><A HREF=volumegraphs.cgi?action=showday&period=20030729&username=dimae>29-07-2003</A></TD>

<TD> </TD>

<TD>319.44</TD>

<TD>0.00</TD>

<TD>185.57</TD>

<TD>505.01</TD>

<TD> </TD>

</TR>

<TR BGCOLOR=f5f5f5 ALIGN=right>

<TD> </TD>

<TD ALIGN=left><A HREF=volumegraphs.cgi?action=showday&period=20030730&username=dimae>30-07-2003</A></TD>

<TD> </TD>

<TD>481.65</TD>

<TD>0.00</TD>

<TD>31.83</TD>

<TD>513.48</TD>

<TD> </TD>

</TR>

<TR BGCOLOR=ffffff ALIGN=right>

<TD> </TD>

<TD ALIGN=left><A HREF=volumegraphs.cgi?action=showday&period=20030731&username=dimae>31-07-2003</A></TD>

<TD> </TD>

<TD>356.81</TD>

<TD>0.00</TD>

<TD>266.57</TD>

<TD>623.38</TD>

<TD> </TD>

</TR>

<TR BGCOLOR=f5f5f5 ALIGN=right>

<TD> </TD>

<TD ALIGN=left><A HREF=volumegraphs.cgi?action=showday&period=20030801&username=dimae>01-08-2003</A></TD>

<TD> </TD>

<TD>9.79</TD>

<TD>0.00</TD>

<TD>0.00</TD>

<TD>9.80</TD>

<TD> </TD>

</TR>

<TR BGCOLOR=ffffff ALIGN=right>

<TD> </TD>

<TD ALIGN=left><A HREF=volumegraphs.cgi?action=showday&period=20030802&username=dimae>02-08-2003</A></TD>

<TD> </TD>

<TD>4.92</TD>

<TD>0.00</TD>

<TD>0.21</TD>

<TD>5.13</TD>

<TD> </TD>

</TR>

<TR BGCOLOR=f5f5f5 ALIGN=right>

<TD> </TD>

<TD ALIGN=left><A HREF=volumegraphs.cgi?action=showday&period=20030803&username=dimae>03-08-2003</A></TD>

<TD> </TD>

<TD>132.40</TD>

<TD>0.00</TD>

<TD>0.16</TD>

<TD>132.57</TD>

<TD> </TD>

</TR>

<TR BGCOLOR=ffffff ALIGN=right>

<TD> </TD>

<TD ALIGN=left><A HREF=volumegraphs.cgi?action=showday&period=20030804&username=dimae>04-08-2003</A></TD>

<TD> </TD>

<TD>16.73</TD>

<TD>0.00</TD>

<TD>0.05</TD>

<TD>16.78</TD>

<TD> </TD>

</TR>

<TR BGCOLOR=ffffff ALIGN=right>

<TD> </TD>

<TD ALIGN=left><A HREF=volumegraphs.cgi?action=showday&period=20030812&username=dimae>12-08-2003</A></TD>

<TD> </TD>

<TD>0.00</TD>

<TD>0.00</TD>

<TD>0.00</TD>

<TD>0.00</TD>

<TD> </TD>

</TR>

<TR ALIGN=right BGCOLOR=#ebebff>

<TD> </TD>

<TD ALIGN=left><B>Total</B></TD>

<TD><B> </TD>

<TD><B>2571.44</B></TD>

<TD><B>364.32</B></TD>

<TD><B>894.37</B></TD>

<TD><B>3830.13</B></TD>

</TBODY>

</TABLE>

[/Quote]

  • Moderators
Robby Newbie

Robby

Posted
  • Moderators
Posted

You can parse the file and load an array or a dataview, and perhaps for each item in the TH tags create the header for each datagrid column.

 

Once the content resides in an array you can Bind it to the datagrid.

Visit...Bassic Software

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...