从XML文件中读取数据绑定到DropDownList

2022-07-15 80酷酷网 80kuku.com

1 、绑定DropDownList：

以下为引用的内容：
ddl_language.DataSource = createDataSource();
    ddl_language.DataTextField = "languageTextField";
    ddl_language.DataValueField = "languageValueField";
    ddl_language.DataBind();

2、上面用到的createDataSource()方法：

以下为引用的内容：
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;
            }

3、Web.config

以下为引用的内容：
<appSettings>

<addkey="LanguageXmlFile"value="d:\Rhombussolution\Rhombus2\Languages.xml"/>
</appSettings>

4、Languages.xml

以下为引用的内容：

<?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>