Hi i am giving below xml as input to the form
<root>
<FirstName></FirstName>
<EmpNumber></EmpNumber>
<language>
<lang>
</data>
<l/ang>
</planguage>
</root>
lang is the repeating node and data is dropdown
I am using mutiple Query to rettive the rows form database and output is the xml below
<language>
<lang>
<data type="VARCHAR">English</data>
</lang>
<lang>
<data type="VARCHAR">UK</data>
</lang>
<lang>
<data type="VARCHAR">India</data>
</lang>
<lang>
<data type="VARCHAR">AUstralia</data>
</lang>
<lang>
<data type="VARCHAR">Africa</data>
</lang>
<lang>
<data type="VARCHAR">Wesindies</data>
</lang>
</language>
Now i want to merge these two XMLs and my output should be as below
<root>
<FirstName></FirstName>
<EmpNumber></EmpNumber>
<language>
<lang>
<data type="VARCHAR">English</data>
</lang>
<lang>
<data type="VARCHAR">UK</data>
</lang>
<lang>
<data type="VARCHAR">India</data>
</lang>
<lang>
<data type="VARCHAR">AUstralia</data>
</lang>
<lang>
<data type="VARCHAR">Africa</data>
</lang>
<lang>
<data type="VARCHAR">Wesindies</data>
</lang>
</language>
</root>
Please help me out wht is the procedure to the above xml result , so i can bind the to the for to diapaly in dropdown.
Thanks in advance
bala