C#中为GridView指定列添加下拉列表

 一、效果图

二、代码

        /// <summary>
        /// 下拉列表值绑定，适用于单列表
        /// </summary>
        /// <param name="gridView"></param>
        /// <param name="strTableName"></param>
        /// <param name="strColumnName">GridView中需绑定的列名</param>
        public void BindComboBoxOfGV(GridView gridView, string strTableName, string strColumnName, string gvColumnName)
        {
            RepositoryItemComboBox cBox = new RepositoryItemComboBox();
            cBox.Items.Clear();

            string strUnitSql = string.Format("SELECT DISTINCT {0} FROM {1}", strColumnName, strTableName);
            DataTable dt = db.GetDataTable(strUnitSql);
            if (dt == null || dt.Rows.Count == 0) return;