循环遍历DataTable,并构建html字符串. IE:
DataTable dt = new DataTable();
dt.Columns.Add("col1");
dt.Columns.Add("col2");
dt.Columns.Add("col3");
dt.Rows.Add(new object[] { "a", "b", "c" });
dt.Rows.Add(new object[] { "d", "e", "f" });
string tab = "\t";
StringBuilder sb = new StringBuilder();
sb.AppendLine("");
sb.AppendLine(tab + "
");sb.AppendLine(tab + tab + "
// headers.
sb.Append(tab + tab + tab + "
");foreach (DataColumn dc in dt.Columns)
{
sb.AppendFormat("
{0}", dc.ColumnName);}
sb.AppendLine("
");// data rows
foreach (DataRow dr in dt.Rows)
{
sb.Append(tab + tab + tab + "
");foreach (DataColumn dc in dt.Columns)
{
string cellValue = dr[dc] != null ? dr[dc].ToString() : "";
sb.AppendFormat("
{0}", cellValue);}
sb.AppendLine("
");}
sb.AppendLine(tab + tab + "
");sb.AppendLine(tab + "");
sb.AppendLine("");