C#中将DataTable导出为XML 格式控制与错误预防

DataTable dt = new DataTable("Users");
dt.Columns.Add("ID", typeof(int));
dt.Columns.Add("Name", typeof(string));
dt.Rows.Add(1, "张三");
<p>using (FileStream fs = new FileStream("output.xml", FileMode.Create))
{
dt.WriteXml(fs, XmlWriteMode.WriteSchema);
}

DataSet ds = new DataSet();
ds.Tables.Add(dt.Copy());
ds.Namespace = "";
ds.RemotingFormat = SerializationFormat.Xml;
<p>StringBuilder sb = new StringBuilder();
StringWriter sw = new StringWriter(sb);
ds.WriteXml(sw, XmlWriteMode.WriteSchema);
string xmlContent = sb.ToString();

public bool ExportToXml(DataTable source, string filePath)
{
    if (source == null || source.Rows.Count == 0) return false;
<pre class="brush:php;toolbar:false;"><pre class="brush:php;toolbar:false;">try
{
    // 检查列名合法性
    foreach (DataColumn col in source.Columns)
    {
        if (!IsLegalXmlName(col.ColumnName))
            throw new ArgumentException($"列名 '{col.ColumnName}' 不是合法的XML标识符");
    }

    using (FileStream fs = new FileStream(filePath, FileMode.Create, FileAccess.Write))
    {
        source.WriteXml(fs, XmlWriteMode.WriteSchema);
    }
    return true;
}
catch (UnauthorizedAccessException)
{
    // 权限不足
    return false;
}
catch (IOException)
{
    // 文件被占用或磁盘错误
    return false;
}

DataTable imported = new DataTable();
imported.ReadXml("output.xml");
if (imported.Rows.Count != originalCount) { /* 告警 */ }