对DropDownList、ComboBox下拉框进行数据绑定

    #region  数据绑定DropDownList控件

    /// <summary>
    /// 数据绑定DropDownList控件方法1
    /// </summary>
    /// <param name="sqlTxt">要查询的SQL语句</param>
    /// <param name="ddlName">绑定的DropDownList控件的名称</param>
    /// <param name="displayMember">DropDownList选项显示内容的绑定字段</param>
    /// <param name="valueMember">DropDownList选项值内容的绑定字段</param>
    public static void BindDropDownList(string cmdTxt, System.Web.UI.WebControls.DropDownList ddlName, string displayMember, string valueMember)
    {
        ddlName.DataSource = FlightDelay.DBUtility.DbHelperSQL.Query(cmdTxt).Tables[0];
        ddlName.DataTextField = displayMember;
        ddlName.DataValueField = valueMember;
        ddlName.DataBind();
    }


    /// <summary>
    /// 数据绑定DropDownList控件方法2
    /// </summary>
    /// <param name="dr">数据阅读器</param>
    /// <param name="ddlName">绑定的DropDownList控件的名称</param>
    /// <param name="displayMember">DropDownList选项显示内容的绑定字段</param>
    /// <param name="valueMember">DropDownList选项值内容的绑定字段</param>
    /// <param name="emptyHead">false不额外添加一个空的头选项，true则添加</param>
    public static void BindDropDownList(System.Data.SqlClient.SqlDataReader dr, System.Web.UI.WebControls.DropDownList ddlName, string displayMember, string valueMember, bool emptyHead)
    {
        if (emptyHead)
            ddlName.Items.Add(new System.Web.UI.WebControls.ListItem("", ""));
        while (dr.Read())
        {
            ddlName.Items.Add(new System.Web.UI.WebControls.ListItem(dr[displayMember].ToString(), dr[valueMember].ToString()));
        }
        dr.Close();
    }
    #endregion

ComboBox绑定的方法与上面相同，改变控件引用就OK了。