1: /// <summary>
2: /// Converts a DataTable to a string with an html table.
3: /// </summary>
4: /// <returns></returns>
5: public static string DataTableToString(DataTable datatable, bool headers)
6: {
7: StringBuilder sb = new StringBuilder();
8:
9: sb.Append("<table border=\"1\">");
10:
11: if (headers)
12: {
13: //write column headings
14: sb.Append("<tr>");
15: foreach (DataColumn datacolumn in datatable.Columns)
16: {
17: sb.Append("<td>" + datacolumn.ColumnName + "</td>");
18: }
19: sb.Append("</tr>");
20: }
21:
22: //write table data
23: foreach (DataRow datarow in datatable.Rows)
24: {
25: sb.Append("<tr>");
26: foreach (DataColumn datacolumn in datatable.Columns)
27: {
28: sb.Append("<td>" + datarow[datacolumn].ToString() + "</td>");
29: }
30: sb.Append("</tr>");
31: }
32: sb.Append("</table>");
33:
34: return sb.ToString();
35: }