How to Convert Sql Server database table to xml file

[PhaniNageshVetcha]

Hi,
This is Phani. I am a software developer on ASP.Net. I want to convert database table to xml file in hierarchial format. id (Primary Key) of the table should be attribute of the table Name tag.
For Example.
System is a database table. The XML File must be following.

<Systems>
<System id=1>
<Name>Respirato ry System</Name>
..
..
</System>
<System id=2>
<Name>Eyes</Name>
..
..
</System>
<System id=3>
<Name>Cardioves cular System</Name>
..
..
</System>
...
..
</Systems>

Please help Me.

[shweta123]

Hi ,

Can you please refer this ,Link

Or

This