Click here to Skip to main content
14,241,358 members
Rate this:
Please Sign up or sign in to vote.
I have a Table that contains directory path some what like this

id  ParentId    Path                            type       Desc
1    -1         Root                              0         a
2     1         Root/Folder1                      0         b
3     1         Root/Folder2                      0         c
4     2         Root/Folder1/abc.dox              1         d
5     3         Root/Folder2/pqr.doc              1         e
6     1         Root/folder3                      0         f
7     6         Root/Folder3/asd.doc              1         g

I want to create xml like this

<Root>
<Folder1 id="2" desc="b"/>
<abc id="4" desc="d"/>
<Folder2 id="3" desc="3"/>
<pqr id="5" desc="e"/>
.
.
.
</Root>

There are around 1000 records and hierarchy is not fixed type indicates 0 - for folder and 1 -for file
Posted
Rate this:
Please Sign up or sign in to vote.

Solution 1

DataTable table = new DataTable() { TableName = "Customer" };

DataColumn keyColumn = table.Columns.Add("id", typeof(System.Int32));
table.Columns.Add("ParentId", typeof(System.Int32));
table.Columns.Add("Path", typeof(System.String));
table.coulmn.Add("type",typeof(System.Char));
table.coulmn.Add("Desc", typeof(System.Char));

table.PrimaryKey = new DataColumn[] { keyColumn };

table.AcceptChanges();


string xmlString = string.Empty;
using (TextWriter writer = new StringWriter())
{
  table.WriteXml(writer);
  xml = writer.ToString();
}
   
Rate this:
Please Sign up or sign in to vote.

Solution 2

SEE THIS LINK[^]
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100