We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Course Of The Month
4 days, 13 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Create customised xml from dataset c#
Posted on 2006-11-14
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.
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.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2 Comments
DataTable dtXmlLink = new DataTable("XmlLink");
dtXmlLink.Columns.Add("Key
dtXmlLink.Columns.Add("Id"
--Loop---
DataRow drXmlLink = dtXmlLink.NewRow();
drXmlLink["Key"]= "";// loop thourgh and add values in to datatable
drXmlLink["Id"]= "";
dtXmlLink.Rows.Add(drXmlLi
---end loop---
{
DataSet ds = new DataSet();
ds.Tables.Add(dtXmlLink );
MemoryStream memStream = new MemoryStream();
StreamReader streamReader = new StreamReader(memStream);
ds.WriteXml(memStream, XmlWriteMode.IgnoreSchema)
memStream.Seek(0, SeekOrigin.Begin);
xmlString = streamReader.ReadToEnd();
}
dtXmlLink.Columns.Add("Key
dtXmlLink.Columns.Add("Id"
--Loop---
DataRow drXmlLink = dtXmlLink.NewRow();
drXmlLink["Key"]= "";// loop thourgh and add values in to datatable
drXmlLink["Id"]= "";
dtXmlLink.Rows.Add(drXmlLi
---end loop---
{
DataSet ds = new DataSet();
ds.Tables.Add(dtXmlLink );
MemoryStream memStream = new MemoryStream();
StreamReader streamReader = new StreamReader(memStream);
ds.WriteXml(memStream, XmlWriteMode.IgnoreSchema)
memStream.Seek(0, SeekOrigin.Begin);
xmlString = streamReader.ReadToEnd();
}
XmlDocument doc = new XmlDocument();
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();
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();
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Introduction
Although it is an old technology, serial ports are still being used by many hardware manufacturers.
If you develop applications in C#, Microsoft .NET framework has SerialPort class to communicate with the serial ports. I needed to…
We all know that functional code is the leg that any good program stands on when it comes right down to it, however, if your program lacks a good user interface your product may not have the appeal needed to keep your customers happy. This issue can…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Suggested Courses
Course of the Month4 days, 13 hours left to enroll
687 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.