use Query From database Which gives to XML String. For Example: Select * from emp "Emplyee" FOR XML Auto Which gives out put like <Emplyee empid="11" ename="rajan" sal="1.200000000000000e+004" ephone="5654645" eAddress="baneshwor" /> <Emplyee empid="12" ename="pravakar" sal="2.500000000000000e+004" ephone="5654645" eAddress="shantinangar" /> <Emplyee empid="13" ename="nilu" sal="2.500000000000000e+004" ephone="5654645" eAddress="ghattekkulo" /> <Emplyee empid="14" ename="shekhar" sal="2.500000000000000e+004" ephone="5654645" eAddress="ekantakuna" /> <Emplyee empid="15" ename="sunil" sal="2.500000000000000e+004" ephone="5654645" eAddress="budanilakantha" /> <Emplyee empid="16" ename="Nilubhai" sal="2.000000000000000e+003" ephone="123456" eAddress="Kathmandu" />

<asp:DropDownList ID="ddl" runat="server"></asp:DropDownList>

ConnectionStringSettingsCollection a = ConfigurationManager.ConnectionStrings;
ListItem lst = new ListItem();
foreach (ConnectionStringSettings s in a)
{
lst = new ListItem(s.ConnectionString, s.ConnectionString);
ddl.Items.Add(lst);
}
ddl.Items.RemoveAt(0);

you can use any loop once it is populated in ConnectionStringSettingsCollection. it populates one connection string from machine.config file. so i have removed 1st one. Hope this will be helpful for u. :laugh: