Extension method to Convert DataTable to HTML Table
By [)ia6l0 iii
Snippet to convert data table to HTML Table
public static string ToHtmlTable(this DataTable myDataTable)
{
StringBuilder sb = new StringBuilder();
//start the table.
sb.AppendLine(""<table width='100%' border='2'>"");
//start the row.
sb.AppendLine(""<tr>"");
//write the columns.
for (int columnCounter = 0; columnCounter <= myDataTable.Columns.Count
- 1; columnCounter++)
{
sb.AppendLine(string.Format(""<th align='left'>{0}</th>"",
myDataTable.Columns[columnCounter]
.ColumnName));
}
//close the row.
sb.AppendLine(""</tr>"");
//add the data.
for (int rowCounter = 0; rowCounter <= myDataTable.Rows.Count - 1;
rowCounter++)
{
sb.AppendLine(""<tr>"");
for (int columnCounter = 0; columnCounter <= myDataTable.Columns.Count
- 1; columnCounter++)
{
sb.AppendLine(""<td >"" +
myDataTable.Rows[rowCounter][columnCounter].ToString() +
""</td>"");
}
sb.AppendLine(""</tr>"");
}
//close the table and create a new line.
sb.AppendLine(""</table><br>"");
//return the html.
return sb.ToString();
}
Extension method to Convert DataTable to HTML Table (3604 Views)