Hi,
I have a select query like this
Select value,key,id from table;
Which returns the result like this
value key id
a 101 1
b 102 1
a 103 2
a 104 2
actully the resultset is in dataset i need to manipulate the dataset and generate the xml
like this
How to generate the xml please help
<AvailableFields>
<Table Name="table1">
<Type Name="a">
<Fields Key="101" id="1"/>
<Fields Key="103" id="2" />
<Fields Key="104" id="2" />
</Type>
<Type Name="b">
<Fields Key="103" id="1"/>
</Type>
</Table>
</AvailableFields>
Regards,
nanban.
doc.LoadXml("<AvailableFie
XmlNode tableNode = doc.DocumentElement.ChildN
DataSet data = new DataSet();
DataTable table = new DataTable("table1");
data.Tables.Add(table);
table.Columns.Add(new DataColumn("value", typeof(string)));
table.Columns.Add(new DataColumn("key", typeof(int)));
table.Columns.Add(new DataColumn("id", typeof(int)));
DataRow newRow = table.NewRow();
newRow.ItemArray = new object[]{"a", 101, 1};
table.Rows.Add(newRow);
newRow = table.NewRow();
newRow.ItemArray = new object[]{"b", 102, 1};
table.Rows.Add(newRow);
newRow = table.NewRow();
newRow.ItemArray = new object[]{"a", 103, 2};
table.Rows.Add(newRow);
newRow = table.NewRow();
newRow.ItemArray = new object[]{"a", 104, 2};
table.Rows.Add(newRow);
foreach(DataRow row in data.Tables[0].Rows){
string type = row["value"].ToString();
string key = row["key"].ToString();
string id = row["id"].ToString();
XmlNode typeNode = tableNode.SelectSingleNode
if (typeNode == null){
typeNode = doc.CreateElement("Type");
((XmlElement)typeNode).Set
tableNode.AppendChild(type
}
XmlElement newField = doc.CreateElement("Fields"
newField.SetAttribute("Key
newField.SetAttribute("id"
typeNode.AppendChild(newFi
}
Console.WriteLine(doc.Oute
Console.ReadLine();