Hi All,
I hope someone can help me. I have loaded a page in my webBrowser control, the page has a table, please see attached for screenshot and partial page source code. I want to load specific column of that table to datagridview, how can I do that?
Thanks in advance.
<DIV style="POSITION: relative; WIDTH: 778px; HEIGHT: 547px" ms_positioning="GridLayout"><table cellspacing="0" cellpadding="0" align="Justify" rules="all" border="1" id="Pager1_ctl00_DataGrid1" style="font-family:Arial;font-size:XX-Small;height:256px;width:761px;border-collapse:collapse;Z-INDEX: 100; POSITION: absolute; TOP: 32px; LEFT: 8px">
<tr style="color:Brown;background-color:Gainsboro;border-color:Brown;border-width:12px;border-style:Solid;font-family:Arial;height:10px;">
<th scope="col">Badge Number</th><th scope="col">Employee Number</th><th scope="col">Employee Name</th><th scope="col">Punch Date</th><th scope="col">Punch Time</th><th scope="col">Punch Type</th><th scope="col">Date Collected</th><th scope="col">Time Collected</th><th scope="col">Terminal Name</th>
</tr><tr style="color:RoyalBlue;background-color:WhiteSmoke;border-color:Transparent;border-width:12px;border-style:Solid;height:5%;">
<td>028197</td><td>GW77</td><td>Lawrence T. Maago</td><td>03-28-2012</td><td>09:46</td><td>In</td><td>03-28-2012</td><td>09:47:21</td><td>LAG-03</td>
</tr><tr style="color:RoyalBlue;background-color:WhiteSmoke;border-color:Transparent;border-width:12px;border-style:Solid;height:5%;">
<td>028197</td><td>GW77</td><td>Lawrence T. Maago</td><td>03-28-2012</td><td>18:17</td><td>Out</td><td>03-28-2012</td><td>18:18:21</td><td>LAG-04</td>
</tr><tr style="color:RoyalBlue;background-color:WhiteSmoke;border-color:Transparent;border-width:12px;border-style:Solid;height:5%;">
<td>028197</td><td>GW77</td><td>Lawrence T. Maago</td><td>03-29-2012</td><td>09:57</td><td>In</td><td>03-29-2012</td><td>09:58:46</td><td>LAG-03</td>
</tr><tr style="color:RoyalBlue;background-color:WhiteSmoke;border-color:Transparent;border-width:12px;border-style:Solid;height:5%;">
<td>028197</td><td>GW77</td><td>Lawrence T. Maago</td><td>03-29-2012</td><td>18:15</td><td>Out</td><td>03-29-2012</td><td>18:15:04</td><td>LAG-04</td>
</tr><tr style="color:RoyalBlue;background-color:WhiteSmoke;border-color:Transparent;border-width:12px;border-style:Solid;height:5%;">
<td>028197</td><td>GW77</td><td>Lawrence T. Maago</td><td>03-30-2012</td><td>09:45</td><td>In</td><td>03-30-2012</td><td>09:46:20</td><td>LAG-03</td>
</tr><tr style="color:RoyalBlue;background-color:WhiteSmoke;border-color:Transparent;border-width:12px;border-style:Solid;height:5%;">
<td>028197</td><td>GW77</td><td>Lawrence T. Maago</td><td>03-30-2012</td><td>18:13</td><td>Out</td><td>03-30-2012</td><td>18:14:50</td><td>LAG-04</td>
</tr><tr style="color:RoyalBlue;background-color:WhiteSmoke;border-color:Transparent;border-width:12px;border-style:Solid;height:5%;">
<td>028197</td><td>GW77</td><td>Lawrence T. Maago</td><td>03-31-2012</td><td>21:50</td><td>In</td><td>03-31-2012</td><td>21:51:20</td><td>LAG-03</td>
</tr><tr style="color:RoyalBlue;background-color:WhiteSmoke;border-color:Transparent;border-width:12px;border-style:Solid;height:5%;">
<td>028197</td><td>GW77</td><td>Lawrence T. Maago</td><td>04-01-2012</td><td>12:10</td><td>Out</td><td>04-01-2012</td><td>12:11:34</td><td>LAG-04</td>
</tr><tr style="color:RoyalBlue;background-color:WhiteSmoke;border-color:Transparent;border-width:12px;border-style:Solid;height:5%;">
<td>028197</td><td>GW77</td><td>Lawrence T. Maago</td><td>04-02-2012</td><td>08:21</td><td>In</td><td>04-02-2012</td><td>08:22:33</td><td>LAG-03</td>
</tr><tr style="color:RoyalBlue;background-color:WhiteSmoke;border-color:Transparent;border-width:12px;border-style:Solid;height:5%;">
<td>028197</td><td>GW77</td><td>Lawrence T. Maago</td><td>04-02-2012</td><td>18:43</td><td>Out</td><td>04-02-2012</td><td>18:44:22</td><td>LAG-04</td>
</tr><tr style="color:RoyalBlue;background-color:WhiteSmoke;border-color:Transparent;border-width:12px;border-style:Solid;height:5%;">
<td>028197</td><td>GW77</td><td>Lawrence T. Maago</td><td>04-03-2012</td><td>09:51</td><td>In</td><td>04-03-2012</td><td>09:52:30</td><td>LAG-03</td>
</tr><tr style="color:RoyalBlue;background-color:WhiteSmoke;border-color:Transparent;border-width:12px;border-style:Solid;height:5%;">
<td>028197</td><td>GW77</td><td>Lawrence T. Maago</td><td>04-03-2012</td><td>18:11</td><td>Out</td><td>04-03-2012</td><td>18:12:28</td><td>LAG-04</td>
</tr><tr style="color:RoyalBlue;background-color:WhiteSmoke;border-color:Transparent;border-width:12px;border-style:Solid;height:5%;">
<td>028197</td><td>GW77</td><td>Lawrence T. Maago</td><td>04-04-2012</td><td>09:58</td><td>In</td><td>04-04-2012</td><td>09:58:56</td><td>LAG-03</td>
</tr><tr style="color:RoyalBlue;background-color:WhiteSmoke;border-color:Transparent;border-width:12px;border-style:Solid;height:5%;">
<td>028197</td><td>GW77</td><td>Lawrence T. Maago</td><td>04-04-2012</td><td>18:38</td><td>Out</td><td>04-04-2012</td><td>18:39:16</td><td>LAG-04</td>
</tr><tr style="color:RoyalBlue;background-color:WhiteSmoke;border-color:Transparent;border-width:12px;border-style:Solid;height:5%;">
<td>028197</td><td>GW77</td><td>Lawrence T. Maago</td><td>04-05-2012</td><td>08:04</td><td>In</td><td>04-05-2012</td><td>08:04:50</td><td>LAG-03</td>
</tr><tr style="color:RoyalBlue;background-color:WhiteSmoke;border-color:Transparent;border-width:12px;border-style:Solid;height:5%;">
<td>028197</td><td>GW77</td><td>Lawrence T. Maago</td><td>04-05-2012</td><td>16:36</td><td>Out</td><td>04-05-2012</td><td>16:37:00</td><td>LAG-04</td>
</tr><tr style="color:RoyalBlue;background-color:WhiteSmoke;border-color:Transparent;border-width:12px;border-style:Solid;height:5%;">
<td>028197</td><td>GW77</td><td>Lawrence T. Maago</td><td>04-06-2012</td><td>10:10</td><td>In</td><td>04-06-2012</td><td>10:10:27</td><td>LAG-03</td>
</tr><tr style="color:RoyalBlue;background-color:WhiteSmoke;border-color:Transparent;border-width:12px;border-style:Solid;height:5%;">
<td>028197</td><td>GW77</td><td>Lawrence T. Maago</td><td>04-06-2012</td><td>19:35</td><td>Out</td><td>04-06-2012</td><td>19:35:40</td><td>LAG-04</td>
</tr><tr style="color:RoyalBlue;background-color:WhiteSmoke;border-color:Transparent;border-width:12px;border-style:Solid;height:5%;">
<td>028197</td><td>GW77</td><td>Lawrence T. Maago</td><td>04-10-2012</td><td>09:54</td><td>In</td><td>04-10-2012</td><td>09:55:07</td><td>LAG-03</td>
</tr><tr style="color:RoyalBlue;background-color:WhiteSmoke;border-color:Transparent;border-width:12px;border-style:Solid;height:5%;">
<td>028197</td><td>GW77</td><td>Lawrence T. Maago</td><td>04-10-2012</td><td>18:15</td><td>Out</td><td>04-10-2012</td><td>18:15:08</td><td>LAG-04</td>
</tr><tr style="color:RoyalBlue;background-color:WhiteSmoke;border-color:Transparent;border-width:12px;border-style:Solid;height:5%;">
<td>028197</td><td>GW77</td><td>Lawrence T. Maago</td><td>04-11-2012</td><td>10:05</td><td>In</td><td>04-11-2012</td><td>10:05:58</td><td>LAG-03</td>
</tr><tr style="color:RoyalBlue;background-color:WhiteSmoke;border-color:Transparent;border-width:12px;border-style:Solid;height:5%;">
<td>028197</td><td>GW77</td><td>Lawrence T. Maago</td><td>04-11-2012</td><td>19:16</td><td>Out</td><td>04-11-2012</td><td>19:17:13</td><td>LAG-04</td>
</tr><tr style="color:RoyalBlue;background-color:WhiteSmoke;border-color:Transparent;border-width:12px;border-style:Solid;height:5%;">
<td>028197</td><td>GW77</td><td>Lawrence T. Maago</td><td>04-12-2012</td><td>09:20</td><td>In</td><td>04-12-2012</td><td>09:21:58</td><td>LAG-03</td>
</tr><tr valign="middle" style="border-color:White;font-family:Arial;font-size:Small;">
<td><span>1</span></td>
</tr>
</table><span id="Pager1_ctl00_lblRecordFound" style="display:inline-block;font-family:Arial;width:177px;Z-INDEX: 102; POSITION: absolute; TOP: 8px; LEFT: 584px">Records Found : 23</span><span id="Pager1_ctl00_Label2" style="Z-INDEX: 103; POSITION: absolute; TOP: 8px; LEFT: 8px">Item per page</span><input name="Pager1$ctl00$TextBox1" type="text" value="50" id="Pager1_ctl00_TextBox1" style="width:64px;Z-INDEX: 104; POSITION: absolute; TOP: 8px; LEFT: 96px" /><input type="submit" name="Pager1$ctl00$Button2" value="Refresh" id="Pager1_ctl00_Button2" style="font-size:XX-Small;Z-INDEX: 105; POSITION: absolute; TOP: 8px; LEFT: 160px" /><input type="submit" name="Pager1$ctl00$Button3" value="Export to Excel" id="Pager1_ctl00_Button3" style="font-size:XX-Small;Z-INDEX: 106; POSITION: absolute; TOP: 8px; LEFT: 216px" /></DIV>
Jump to PostYou might have to try to parse the HTML content of the website.
You might have to try to parse the HTML content of the website.
can you show me some code?
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.