dynamic generation of xml tag from one table or more than one table in asp.net

See more:

ASP.NET

Hi sir pls help how to generate the xml file dynamically from one or two table and the tag should be user defined example from employee table empname , empage should come under parent tag like employee detail in that employee detail tag is having one more tag called employeeinfo containg salary pls see below format

< employee xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="file1.xsd">
<header data></header data>

<employeedetail>
<empname>abc</employeename>
<empage >23</empage>
<employeeinfo>
<empsal> 5000</empsal>
</employeeinfo>
</employeedetail>