1    private string GetDataTableAsHTML(DataTable thisTable)
2    {
3        System.Text.StringBuilder sb = new System.Text.StringBuilder();
4
5        sb.AppendFormat(@"<caption> Total Rows =");
6        sb.AppendFormat(thisTable.Rows.Count.ToString());
7        sb.AppendFormat(@"  </caption>");
8        
9        sb.Append("<TABLE BORDER=1>");
10        
11        sb.Append("<TR ALIGN='CENTER'>");
12        
13        //first append the column names.
14        foreach (DataColumn column in thisTable.Columns)
15        {
16            sb.Append("<TD><B>");
17            sb.Append(column.ColumnName);
18            sb.Append("</B></TD>");
19        }
20        
21        sb.Append("</TR>");
22        
23        // next, the column values.
24        foreach (DataRow row in thisTable.Rows)
25        {
26            sb.Append("<TR ALIGN='CENTER'>");
27            
28            foreach (DataColumn column in thisTable.Columns)
29            {
30                sb.Append("<TD>");
31                if (row[column].ToString().Trim().Length > 0)
32                    sb.Append(row[column]);
33                else
34                    sb.Append(" ");
35                sb.Append("</TD>");
36            }
37
38            sb.Append("</TR>");
39        }
40        sb.Append("</TABLE>");
41        
42        return sb.ToString();
43    }