having trouble loading XML into dropdownlist control

Question

I'm working with a GridView table and have a dropdown control inside of it. my main task here is create a cascading dropdown with a webpart I'm designing. to that end, the XML file is supposed to supply the values to it.

I have code inside the page load function which is supposed to load the XML file but it always comes up blank and I don't know why.

Here is an example of the C# code:

 DataSet DS = new DataSet(); string physicalPath = HttpContext.Current.Server.MapPath("../FormA/XML-FS.xml"); string webPath = HttpContext.Current.Server.MapPath("http://hsphxvsp2010t:20103/_catalogs/masterpage/XML-FS1.xml"); DS.ReadXml(webPath); ddlFundingSource.DataTextField = "fsName"; ddlFundingSource.DataValueField = "fsID"; //ddlFundingSource.DataSource = DS.Tables[0].DefaultView; ddlFundingSource.DataSource = DS; ddlFundingSource.DataBind(); 

Have tried both path strings, to no avail as well as the XmlDataSource control which is seemingly broken altogether.

and my XML.

<fundingSources> <fundingSource> <fsID>1</fsID> <fsName>NYC</fsName> </fundingSource> <fundingSource> <fsID>2</fsID> <fsName>Upstate</fsName> </fundingSource> <fundingSource> <fsID>3</fsID> <fsName>Adirondacks</fsName> </fundingSource> <fundingSource> <fsID>4</fsID> <fsName>Downstate</fsName> </fundingSource> </fundingSources> 

what is wrong here?

Answer 1

If that is your complete XML, then you are missing your start tag and the XML is not well formed.

<fundingSources>