I have a simple XML file for US states formatted as follows:
<states>
    <state>
        <state_name>Alabama</state_name>
        <abbreviation>AL</abbreviation>
    </state>
    <state>
        <state_name>Alaska</state_name>
        <abbreviation>AK</abbreviation>
    </state>
etc...
</states>

How do I bind to a drop down list so that the state_name is displayed but the abbreviation is the actual value of the row?

Check this link:
http://www.w3schools.com/aspnet/aspnet_xml.asp

You first have to import the XML into a dataset, then bind to the dataset.

Jim

This is great. You can use the dataset to do it quicky this link show you how to do it nicely. http://www.itjungles.com/dropdownlis...-with-xml-in-c

The above example is great to pull the value out from XML file, but, what happens you multiple dropdowns as opposed to a single dropdown above?

//Declare SqlCommand
SqlCommand cmd;
//Declare SqlAdapter
SqlDataAdapter da;
//Decalre Dataset
DataSet ds;

//Declare String
string strQuery;

//Query
strQuery = "Select Column_Id,Column_Desc from Test_Table";

//decalre Connection to DB
SqlConnection con = default(SqlConnection);

//Connection String to SQL 2005
con = new SqlConnection("Data Source=MYServer-PC\\SQLEXPRESS;Initial Catalog=Sample_New;User Id=sa;Password=test@123;");

try
{
cmd = new SqlCommand(strQuery, con);
da = new SqlDataAdapter(cmd);
ds = new DataSet();
da.Fill(ds);
if (con.State != ConnectionState.Closed)
{
con.Close();
}
wddltest.DataSource = ds;


wddltest.DataTextField = "Column_Desc";
wddltest.DataValueField = "Column_Id";
wddltest.DataBind();
//wddltest.Items.Insert(0, New ListItem("All", "0"));

}
catch (Exception ex)
{
con.Close();
throw new Exception(ex.Message, ex);
}

More info visit :http://www.book4dotnet.com/

Any way to do this locally in the browser without a server?