Demo: Dictionary>> 泛型读取XML文件数据作为数据源（DataSource）绑定到DropDownList控件 定义个一个公用类

true_suffix_name.DataSource = Common.OptionDictionary["suffix"];
            true_suffix_name.DataTextField = "key";
            true_suffix_name.DataValueField = "value";

 

using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

using System.IO;
using ASPSOFT.Utility;
using System.Collections.Generic;
using System.Collections;
using System.Xml;

/**//// <summary>
/// Summary description for Common
/// </summary>
public class Common
{
    public Common()
    {
        //
        // TODO: Add constructor logic here
        //
    }

    private static Dictionary<string, List<KeyValuePair<string, string>>> _optionDictionary; //= new Dictionary<string, List<KeyValuePair<string, string>>>();

    public static Dictionary<string, List<KeyValuePair<string, string>>> OptionDictionary
    {
        get {
            if (null == _optionDictionary)
                _optionDictionary = new Dictionary<string, List<KeyValuePair<string, string>>>();

            if (_optionDictionary.Count == 0)// 0
            {
                string strXMLFile = HttpContext.Current.Server.MapPath("~/TCR_SQL.xml");
                if (File.Exists(strXMLFile)) // file
                {
                    //read sql clause from the xml file (suffix,race,sex,state,xref_no etc)
                    XmlDocument xmldoc = new XmlDocument();
                    try
                    {
                        xmldoc.Load(strXMLFile);
                        XmlNodeList sqlNodeList = xmldoc.SelectSingleNode("collect").ChildNodes;

                        foreach (XmlNode xn in sqlNodeList)
                        {
                            XmlElement xe = (XmlElement)xn;
                            _optionDictionary.Add(xe.GetAttribute("item").ToLower(), GetEnumsFromTable(xe.InnerText));
                        }
                    }
                    catch
                    { }

                    // directly use sql string clause
                    string[][] sqlKeyValueList = new string[][]{ 
                             new string[]{ "JuvenileAdult","SELECT VARCHAR3, CODE FROM .."}
                            ,new string[]{ "HairColor","select description, code from .."}
                            ,new string[]{ "EyeColor","select description, code from .."}
                            ,new string[]{ "CitizenshipCCLV","select code1=code, code from .."}
                            ,new string[]{ "VAF","select code1=code, code from .."}
                            ,new string[]{ "PD","select asso_name, asso_id  from .."}
                            ,new string[]{ "YesNo","select description, code from .."}
                        };

                    for (int i = 0; i < sqlKeyValueList.Length; i++)
                    {
                        try
                        {
                            _optionDictionary.Add(sqlKeyValueList[i][0].ToLower(), GetEnumsFromTable(sqlKeyValueList[i][1]));
                        }
                        catch
                        { }
                    }
                }//end file
                else
                {
                    throw new Exception("TCR_SQL.xml file doesn't exist");
                }
            }//end 0
            return _optionDictionary;
        } // end get
    }

    public static void AddOption(string key, string value)
    {
        if (OptionDictionary.ContainsKey(key))
        {
            OptionDictionary[key].Add(new KeyValuePair<string, string>(value, value));
        }
        else
        {
            List<KeyValuePair<string, string>> objData = new List<KeyValuePair<string, string>>();
            objData.Add(new KeyValuePair<string, string>(value, value));
            OptionDictionary.Add(key, objData);
        }
    }

    private static List<KeyValuePair<string, string>> GetEnumsFromTable(string strSql)
    {
        List<KeyValuePair<string, string>> ht = new List<KeyValuePair<string, string>>();

        ht.Add(new KeyValuePair<string, string>("", ""));

        if (!string.IsNullOrEmpty(strSql))
        {
            DataTable dt = DALHelper.GetDataTable(strSql);
            if (null != dt && dt.Columns.Count == 2)
            {
                foreach (DataRow row in dt.Rows)
                {
                    try
                    {
                        ht.Add(new KeyValuePair<string, string>(row[0].ToString(), row[1].ToString()));
                    }
                    catch 
                    { }
                }
            }
        }

        return ht;
    }
}

XML 文件：

<?xml version="1.0" ?>
<collect>
 <sql item="received_by">
  select staff_name, staff_id from staff where (staff_type='INVESTIGATOR' or staff_type='AGENT') and flag_delete=0 order by staff_name
 </sql>
 <sql item="municipality_code">
  select description, code from asp_lookup where lookup_id='municipality' and varchar10='DCOUNTY' and display = 'Y' order by description
 </sql>
</collect>