如何以易读的格式显示来自WriteXml的DataTable XML

试试吧。将DataTable序列化为XML的最简单方法可能是:

DataTable table = new DataTable();    
System.IO.StringWriter writer = new System.IO.StringWriter();
//notice that we're ignoring the schema so we get clean XML back
//you can change the write mode as needed to get your result
table.WriteXml(writer, XmlWriteMode.IgnoreSchema, false);
string dataTableXml = writer.ToString();

至于以可读格式显示，我建议将XML传递给XSL转换器，然后可以使用它来解析XML并根据需要操作输出。

对数据集应用XSLT转换

http://msdn.microsoft.com/en-us/library/8fd7xytc%28v=vs.71%29.aspx Y289

下面是我创建的一个简单示例，用于解释如何使用XSL转换器。我还没有测试过，但应该非常接近:

DataSet ds = new DataSet();
StringBuilder sbXslOutput = new StringBuilder();
using (XmlWriter xslWriter = XmlWriter.Create(sbXslOutput))
{
    XslCompiledTransform transformer = new XslCompiledTransform();
    transformer.Load("transformer.xsl");
    XsltArgumentList args = new XsltArgumentList();
    transformer.Transform(new XmlDataDocument(ds), args, xslWriter);
}
string dataSetHtml = sbXslOutput.ToString();

使用XSLT将XML格式化为HTML

下面是使用XSLT将XML转换为HTML表的示例。它应该是相当容易采用，所以你可以使用它与你的序列化数据集。

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
  <xsl:template match="/">
      <table border="1">
        <tr>
          <th>User Login</th>
          <th>Matter Number</th>
          ...
        </tr>
        <xsl:for-each select="NewDataSet/RecentMatter">
          <tr>
            <td>
              <xsl:value-of select="UserLogin"/>
            </td>
            <td>
              <xsl:value-of select="MatterNumber"/>
            </td>
            ...
          </tr>
        </xsl:for-each>
      </table>
  </xsl:template>
</xsl:stylesheet>

我建立的这个方法可能对你有用(如果你喜欢的话，可以删除dash装饰…)。它应该像这样呈现表格:

+----------+----------+----------+
| Column1  | Column2  | Column3  |
+----------+----------+----------+
| asdfasdf | asdfasdf | asdfasdf |
| asdfasdf | asdfasdf | asdfasdf |
| asdfasdf | asdfasdf | asdfasdf |
+----------+----------+----------+

代码如下:

public void WriteTable(DataTable table, Stream outputStream)
{
    // Create writer
    StreamWriter writer = new StreamWriter(outputStream);
    // Compute max lengths to build correct tabular columns
    Dictionary<string, int> maxLengths = new Dictionary<string, int>();
    foreach (DataColumn column in table.Columns)
    {
        maxLengths.Add(column.ColumnName, column.ColumnName.Length);
        foreach (DataRow row in table.Rows)
        {
            maxLengths[column.ColumnName] = Math.Max(
                maxLengths[column.ColumnName], 
                Convert.ToString(row[column.ColumnName]).Length);
        }
    }
    // Build horizontal rule to separate headers from data
    string horizontalRule = "+";
    foreach (DataColumn column in table.Columns)
    {
        horizontalRule += String.Format("-{0}-+", new string('-', maxLengths[column.ColumnName]));
    }
    writer.WriteLine(horizontalRule);
    // Write headers
    writer.Write("|");
    foreach (DataColumn column in table.Columns)
    {
        writer.Write(" {0," + (-(maxLengths[column.ColumnName])) + "} |", column.ColumnName);
    }
    writer.WriteLine();
    writer.WriteLine(horizontalRule);
    // Write data
    foreach (DataRow row in table.Rows)
    {
        writer.Write("|");
        foreach (DataColumn column in table.Columns)
        {
            writer.Write(" {0," + (-(maxLengths[column.ColumnName])) + "} |", row[column.ColumnName]);
        }
        writer.WriteLine();
    }
    writer.WriteLine(horizontalRule);
    // Close writer
    writer.Close();
}