35
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
rowTable.Columns["ROWDATA_Id"].DefaultValue = 0;
29
var newRow = rowTable.NewRow();
30
newRow["CompanyID"] = "APPL";
31
newRow["Description"] = "Apple";
32
rowTable.Rows.Add(newRow);
33
Console.WriteLine(dataSet.GetXml());
34
}
35
}
Cached Result