asp.net实现XML文件读取数据绑定到DropDownList的方法

ddl_language.DataSource = createDataSource();ddl_language.DataTextField = "languageTextField";ddl_language.DataValueField = "languageValueField";ddl_language.DataBind();

private ICollection createDataSource(){ //create a data table to store the data for the ddl_langauge control DataTable dt = new DataTable(); //define the columns of the table dt.Columns.Add("languageTextField",typeof(string)); dt.Columns.Add("languageValueField",typeof(string)); //read the content of the xml file into a DataSet DataSet lanDS = new DataSet(); string filePath = ConfigurationSettings.AppSettings["LanguageXmlFile"]; lanDS.ReadXml(filePath); if(lanDS.Tables.Count > 0) {   foreach(DataRow copyRow in lanDS.Tables[0].Rows)   {      dt.ImportRow(copyRow);   } } DataView dv = new DataView(dt); return dv;}

<appSettings>  <!--The file path for the language type xml file-->  <addkey="LanguageXmlFile"value="d:/Rhombussolution/Rhombus2/Languages.xml"/></appSettings>

<?xmlversion="1.0"encoding="utf-8"?><languageTypes>  <language>   <languageValueField>en-US</languageValueField>   <languageTextField>English</languageTextField>  </language>  <language>   <languageValueField>zh-CN</languageValueField>   <languageTextField>中文</languageTextField>  </language>  <language>   <languageValueField>ja-JP</languageValueField>   <languageTextField>日语</languageTextField>  </language></languageTypes>