Bind Dropdownlist with xml file in asp.net

Question

Hi,
I have a xml file and i wann bind these file in dropdownlist.
I wann on city and country code in dropdown list.


Xml Files Content
<DocumentElement>
<Table1>
<id>1</id>
<name>Saint John</name>
<city_code />
<country_code>CA</country_code>
</Table1>
<Table1>
<id>2</id>
<name>Baddeck</name>
<city_code />
<country_code>CA</country_code>
</Table1>
<Table1>
<id>3</id>
<name>Banff</name>
<city_code />
<country_code>CA</country_code>
</Table1>
 </DocumentElement>