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

对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