Create an HTML table from ADO.NET Dataset (requires 1.4 SR-1)

Create an HTML table from ADO.NET Dataset (requires 1.4 SR-1)



1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
#macro( main $ds )
#set( $table = $ds.Tables.get_Item(0) )
<table>
<tbody>
    <tr>
#foreach($col in $table.Columns)
        <th>$col.ColumnName</th>
#end
    </tr>
#foreach($row in $table.Rows)
    <tr>
#foreach($col in $table.Columns)
        <td>$row.get_Item($col.ColumnName)</td>
#end
    </tr>
#end
</tbody>
</table>
#end
#main( $ds )