c html转为datatable,C# DataTable转换为Html

///

///DataTable 转换为 Html///

///

///

public stringGetHtmlString(DataTable dt)

{

StringBuilder sb= newStringBuilder();

sb.Append("

");

sb.Append("

Excel转换为Table");

sb.Append("");

sb.Append("

sb.Append("td{font-size: 9pt;border:solid 1 #000000;}");

sb.Append("table{padding:3 0 3 0;border:solid 1 #000000;margin:0 0 0 0;BORDER-COLLAPSE: collapse;}");

sb.Append("");

sb.Append("");

sb.Append("

");

sb.Append("

sb.Append("

");

sb.Append("

");foreach (DataColumn column indt.Columns)

{

sb.Append("

" + column.ColumnName + "");

}

sb.Append("

");int iColsCount =dt.Columns.Count;int rowsCount = dt.Rows.Count - 1;for (int j = 0; j <= rowsCount; j++)

{

sb.Append("

");

sb.Append("

" + ((int)(j + 1)).ToString() + "");for (int k = 0; k <= iColsCount - 1; k++)

{

sb.Append("

");object obj =dt.Rows[j][k];if (obj ==DBNull.Value)

{

obj= " ";//如果是NULL则在HTML里面使用一个空格替换之

}if (obj.ToString() == "")

{

obj= " ";

}string strCellContent =obj.ToString().Trim();

sb.Append("" + strCellContent + "");

sb.Append("

");

}

sb.Append("

");

}

sb.Append("

");//点击单元格 输出 行和列

sb.Append("");

sb.Append("

sb.Append("$('table tbody').on('click', 'td', function (e) {");

sb.Append("var row = $(this).parent().prevAll().length-1 ;");

sb.Append("var column = $(this).prevAll().length-1 ;");

sb.Append("var str = 'dt.Rows[' + row + '][' + column + '].ToString()';");

sb.Append("console.log(str);alert(str);");

sb.Append("});");

sb.Append("");

sb.Append("");returnsb.ToString();

}