datatable 转化成html,把dataTable数据转换为Html

using System;

using System.Collections.Generic;

using System.Data;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace CommonSchedule

{

public class DataTableToHtml

{

#region 把DataTable轉換成Html

///

/// 把DataTable轉換成Html

///

/// DataTable

///

public string GetHtmlByDataTable(DataTable dt)

{

StringBuilder sbHtml = new StringBuilder();

sbHtml.Append("

sbHtml.Append("

");

string[] str = { "style=\"background-color:#dda29a;\"", "style=\"background-color:#d98722;\"", "style=\"background-color:#cfbd2d;\"", "style=\"background-color:#cbd12c;\"", "style=\"background-color:#91ca15;\"", "style=\"background-color:#6dc71e;\"", "style=\"background-color:#25b25c;\"", "style=\"background-color:#13a7a2;\"" };

string aligns = "align=\"right\"";

for (int i = 0; i < dt.Columns.Count; i++)

{

sbHtml.Append("

sbHtml.Append(str[i]);

sbHtml.Append(" >");

sbHtml.Append(dt.Columns[i].ColumnName);

sbHtml.Append("

");

}

sbHtml.Append("

");

for (int i = 0; i < dt.Rows.Count; i++)//行

{

sbHtml.Append("

");

for (int j = 0; j < dt.Columns.Count; j++)

{

sbHtml.Append("

sbHtml.Append(aligns);

sbHtml.Append(" >");

sbHtml.Append(dt.Rows[i][j]);

sbHtml.Append("

");

}

sbHtml.Append("

");

}

sbHtml.Append("

");

return sbHtml.ToString();

}

#endregion

#region  把DataTable轉換成Html

///

/// 把DataTable轉換成Html

///

/// DataTable

/// Egg:

///

public string GetHtmlByDataTable(DataTable dt,string style)

{

StringBuilder sbHtml = new StringBuilder();

sbHtml.Append(style);

sbHtml.Append("

sbHtml.Append("

");

string[] str = { "style=\"background-color:#dda29a;\"", "style=\"background-color:#d98722;\"", "style=\"background-color:#cfbd2d;\"", "style=\"background-color:#cbd12c;\"", "style=\"background-color:#91ca15;\"", "style=\"background-color:#6dc71e;\"", "style=\"background-color:#25b25c;\"", "style=\"background-color:#13a7a2;\"" };

string aligns = "align=\"right\"";

for (int i = 0; i < dt.Columns.Count; i++)

{

sbHtml.Append("

sbHtml.Append(str[i]);

sbHtml.Append(" >");

sbHtml.Append(dt.Columns[i].ColumnName);

sbHtml.Append("

");

}

sbHtml.Append("

");

for (int i = 0; i < dt.Rows.Count; i++)//行

{

sbHtml.Append("

");

for (int j = 0; j < dt.Columns.Count; j++)

{

sbHtml.Append("

sbHtml.Append(aligns);

sbHtml.Append(" >");

sbHtml.Append(dt.Rows[i][j]);

sbHtml.Append("

");

}

sbHtml.Append("

");

}

sbHtml.Append("

");

return sbHtml.ToString();

}

#endregion

}

}