34
1
using System;
2
using System.Data;
3
using System.IO;
4
using System.Xml;
5
6
public class Program
7
{
8
public static void Main()
9
{
10
string xml = @"<?xml version=""1.0"" encoding=""UTF-8"" standalone=""yes""?>
11
<DATAPACKET Version=""2.0"">
12
<METADATA>
13
<FIELDS>
14
<FIELD attrname=""CompanyID"" fieldtype=""string"" WIDTH=""10""/>
15
<FIELD attrname=""Description"" fieldtype=""string"" WIDTH=""40""/>
16
</FIELDS>
17
<PARAMS/>
18
</METADATA>
19
<ROWDATA>
20
<ROW CompanyID=""CC"" Description=""Contoso""/>
21
</ROWDATA>
22
</DATAPACKET>
23
";
24
XmlReader reader = XmlReader.Create(new StringReader(xml));
25
DataSet dataSet = new DataSet();
26
dataSet.ReadXml(reader, XmlReadMode.InferTypedSchema);
27
var rowTable = dataSet.Tables["ROW"];
28
var newRow = rowTable.NewRow();
29
newRow["CompanyID"] = "APPL";
30
newRow["Description"] = "Apple";
31
rowTable.Rows.Add(newRow);
32
Console.WriteLine(dataSet.GetXml());
33
}
34
}
Cached Result
<DATAPACKET Version="2.0">
<METADATA>
<PARAMS />
<FIELDS>
<FIELD attrname="CompanyID" fieldtype="string" WIDTH="10" />
<FIELD attrname="Description" fieldtype="string" WIDTH="40" />
</FIELDS>
</METADATA>
<ROWDATA>
<ROW CompanyID="CC" Description="Contoso" />
<ROW CompanyID="APPL" Description="Apple" />
</ROWDATA>
</DATAPACKET>
<METADATA>
<PARAMS />
<FIELDS>
<FIELD attrname="CompanyID" fieldtype="string" WIDTH="10" />
<FIELD attrname="Description" fieldtype="string" WIDTH="40" />
</FIELDS>
</METADATA>
<ROWDATA>
<ROW CompanyID="CC" Description="Contoso" />
<ROW CompanyID="APPL" Description="Apple" />
</ROWDATA>
</DATAPACKET>