Linking 3 XML, grouping 3 XML

EDN Admin · May 22, 2012

Hi Linq to XML experts,
I have what I think is a fairly simple request - to link a ListView to some XML output that happens to exist in 3 separate XML files. Ive been trying to use LINQ to XML to get these joined and grouped together and output to the ListView. Here
are the 3 example XML files:
XML 1:
<wantedlist>
 
<wanted> <nameid>1</nameid>
 
<name>NAME1</name>
 
<age>38</age> <height>6 ft. 00 in.</height>
 
<weight>180</weight>
 
<hair>BLK</hair> <eyes>BRO</eyes>
 
<image>NAME1.JPG</image> </wanted>
 

 
<wanted> <nameid>2</nameid>
 
<name>NAME2</name>
 
<age>34</age> <height>6 ft. 00 in.</height>
 
<weight>200</weight>
 
<hair>BLN</hair> <eyes>BLU</eyes>
 
<image>NAME2.JPG</image> </wanted>
 

 
<wanted> <nameid>3</nameid>
 
<name>NAME3</name>
 
<age>44</age> <height>5 ft. 10 in.</height>
 
<weight>230</weight>
 
<hair>BLK</hair> <eyes>BRO</eyes>
 
<image>NAME3.JPG</image> </wanted>
 

 
<wanted> <nameid>4</nameid>
 
<name>NAME4 </name>
 
<age>37</age> <height>5 ft. 04 in.</height>
 
<weight>150</weight>
 
<hair>BRO</hair> <eyes>BRO</eyes>
 
<image>NAME4.JPG</image> </wanted>
 
</wantedlist>
XML 2:
<aliaslist>
 
<alias> <nameid>1</nameid>
 
<a_name>BAD GUY 1 </a_name> </alias>
 

 
<alias> <nameid>2</nameid>
 
<a_name>BAD GUY 2 </a_name> </alias>
 

 
<alias> <nameid>2</nameid>
 
<a_name>REALLY BAD GUY </a_name> </alias>
 

 
<alias> <nameid>2</nameid>
 
<a_name>SERIOUSLY BAD GUY </a_name> </alias>
 

 
<alias> <nameid>3</nameid>
 
<a_name>BAD GUY 3 </a_name> </alias>
 

 
<alias> <nameid>3</nameid>
 
<a_name>PRETTY MEAN GUY </a_name> </alias> 
</aliaslist>
XML 3:
<chargelist>
 
<charges> <nameid>1</nameid>
 
<charge>JAYWALKING 1</charge>
 
<bail>$10,000</bail> </charges>
 

 
<charges> <nameid>2</nameid>
 
<charge>LITTER 2</charge>
 
<bail>$25,000</bail> </charges>
 

 
<charges> <nameid>2</nameid>
 
<charge>GUM CHEWING</charge>
 
<bail>$500,000</bail> </charges>
 

 
<charges> <nameid>2</nameid>
 
<charge>INFRACTION 1</charge> 
<bail>$5,000</bail> </charges>
 

 
<charges> <nameid>3</nameid>
 
<charge>JAYWALKING 2</charge>
 
<bail>$100,000</bail> </charges>
 

 
<charges> <nameid>3</nameid>
 
<charge>NAME CALLING</charge>
 
<bail>$2,500</bail> </charges>
 

 
<charges> <nameid>4</nameid>
 
<charge>INFRACTION 3</charge>
 
<bail>$5,000</bail> </charges> 
</chargelist>
I have been using C# in VS 2010 and some of the following code:<span style="font-size:small <span lang="
<span style="font-size:small chrgs = 
aname = 


<span style="font-size:small <span style="font-size:small <span lang="EN <span style="color:#2b91af; font-size:small <span style="color:#2b91af; font-size:small <span lang=" Var new =
<span style="font-size:small <span style="font-size:small <span style="color:#2b91af; font-size:small <span style="color:#2b91af; font-size:small <span lang=" <span style="font-size:small <span style="font-size:small <span style="color:#2b91af; font-size:small <span style="color:#2b91af; font-size:small <span style="font-size:small <span style="font-size:small <span style="color:#2b91af; font-size:small <span style="color:#2b91af; font-size:small <span lang=" <span lang="EN <span style="color:#0000ff from<span style="font-size:small
wnt <span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small in
<span style="font-size:small <span style="font-size:small <span lang="EN j<span lang=" <span lang=" <span lang=" <span lang=" <span style="font-size:small c
<span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small in
<span style="font-size:small <span style="font-size:small <span lang="EN <span lang="EN <span lang="EN <span lang="EN <span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small <span lang=" on<span lang=" <span lang=" <span lang=" <span style="font-size:small
wnt.Element(<span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small "nameid"<span style="font-size:small ).Value
<span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small equals
<span style="font-size:small <span style="font-size:small <span lang="EN <span lang="EN <span lang="EN <span lang="EN <span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small <span lang=" join<span lang=" <span lang=" <span lang=" <span style="font-size:small
a <span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small in
<span style="font-size:small <span style="font-size:small <span lang="EN <span lang="EN <span lang="EN <span lang="EN <span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small <span lang=" on<span lang=" <span lang=" <span style="font-size:small
wnt.Element(<span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small "nameid"<span style="font-size:small ).Value
<span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small equals
age = (string)wnt.Element("age"), 
height = (string)wnt.Element("height"), 
weight = (string)wnt.Element("weight"), 
hair = (string)wnt.Element("hair"), 
eyes = (string)wnt.Element("eyes"), 
image = (string)wnt.Element("image"), 
charge = (string)c.Element("charge"), 
bail = (string)c.Element("bail"), 
alias = (string)a.Element("a_name")} into g
 
select new 
{ 
g.Key.name, 
//how to iterate through alias names grouped by single name
<span style="font-size:small <span style="font-size:small <span style="color:#2b91af; font-size:small <span style="color:#2b91af; font-size:small <span style="font-size:small <span style="font-size:small <span style="color:#2b91af; font-size:small <span style="color:#2b91af; font-size:small <span style="font-size:small <span style="font-size:small <span style="color:#2b91af; font-size:small <span style="color:#2b91af; font-size:small <span lang=" <span style="font-size:small <span style="font-size:small <span style="font-size:small <span style="font-size:small <span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small <span style="font-size:small <span style="font-size:small <span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small 
g.Key.age, 
g.Key.height, 
g.Key.weight, 
g.Key.hair, 
g.Key.eyes, 
g.Key.image 

 
}; 
ListView.Datasource = new.ToList(); 
ListView.Bind();
<span lang="EN How can I get this formatted in order to get the unique name, all aliases associated with that nameid, and all charges as one distinct row into a ListView? Please let me know - Ive gotten close but I dont have the joining
and grouping correct.
<span lang="EN Thanks for your assistance with this.
<span lang="EN Jim
<span style="font-size:small <span style="font-size:small <span lang="EN

View the full article

Linking 3 XML, grouping 3 XML

EDN Admin

Well-known member