c# using HtmlAgilityPack to get data from HTML table

<table>

<div id="cal_nav" class="float_right"><ul class="inline">

<li> Calendar View

</li> <li> Bulk Update View </li>

<li id="previous" class="first"> </li><li id="next"> </li></ul></div>October 2015



<thead>
<tr>
<th>Date</th>
<th>Occupancy</th>
<th>Net Rate</th>
<th>Sell Rate</th>
</tr>
</thead>

<tbody>
<input type="hidden" name="rateid" value="234154166">
<tr><td>1</td><td>single</td><td>1652</td><td>2500</td></tr>
<tr><td>2</td><td>single</td><td>1454</td><td>4344</td></tr>
<input type="hidden" name="rateid" value="234154134">
<tr><td>1</td><td>single</td><td>1652</td><td>2500</td></tr>
<tr><td>2</td><td>single</td><td>1454</td><td>4344</td></tr>
<input type="hidden" name="rateid" value="234154145">
<tr><td>1</td><td>single</td><td>1652</td><td>2500</td></tr>
<tr><td>2</td><td>single</td><td>1454</td><td>4344</td></tr>
</tbody>

</table>


MY Linq code:


var tds= (from td in doc.DocumentNode.Descendants("table")
select td).ToList()[2].ChildNodes[2];

var trer = tdsyh.SelectNodes("//input[@type='hidden' and @name='rateid']|tr").Select(x => x).ToList();