111,126
社区成员
发帖
与我相关
我的任务
分享 static void Main(string[] args)
{
DataTable ToTable = new DataTable();
ToTable.Columns.Add(new DataColumn("ID", typeof(string)));
ToTable.Rows.Add("1");
ToTable.Prefix = "";
ToTable.Namespace = "http://tempuri.org/TMapping.xsd";
ToTable.TableName = "TMappings";
Write(ToTable, @"E:\ConsoleApplication1\test.xml", "TMapping");
}
static void Write(DataTable table, string fileName, string StartElementName)
{
XmlWriterSettings settings = new XmlWriterSettings();
settings.CheckCharacters = true;
settings.CloseOutput = true;
settings.ConformanceLevel = ConformanceLevel.Document;
settings.Encoding = System.Text.Encoding.UTF8;
settings.Indent = false;
settings.NewLineHandling = NewLineHandling.Replace;
settings.NewLineOnAttributes = true;
settings.OmitXmlDeclaration = false;
using (XmlWriter writer = XmlWriter.Create(fileName, settings))
{
writer.WriteStartDocument(true);
WriteTable(writer, table, StartElementName);
writer.WriteEndDocument();
}
}
static void WriteTable(XmlWriter writer, DataTable table,string StartElementName)
{
writer.WriteStartElement(StartElementName);
foreach (DataRow row in table.Rows)
{
writer.WriteStartElement(table.TableName);
foreach (DataColumn column in table.Columns)
{
writer.WriteStartElement(column.ColumnName);
writer.WriteValue(row[column].ToString());
writer.WriteEndElement();
}
writer.WriteEndElement();
}
writer.WriteEndElement();
}
static void Main(string[] args)
{
DataSet ds = new DataSet();
DataTable ToTable = new DataTable();
ds.Tables.Add(ToTable);
ToTable.Columns.Add("ID");
DataRow Row = ToTable.NewRow();
Row["ID"] = "1";
ToTable.Rows.Add(Row);
ToTable.DataSet.DataSetName = "TMapping";//报错
ToTable.Prefix = "";
ds.Namespace = "http://tempuri.org/TMapping.xsd";
// ToTable.Namespace = "http://tempuri.org/TMapping.xsd";
ToTable.TableName = "TMappings";
ToTable.WriteXml("test.xml");
}
<?xml version="1.0" standalone="yes"?>
<TMapping xmlns="http://tempuri.org/TMapping.xsd">
<TMappings>
<ID>1</ID>
</TMappings>
</TMapping>