winform将含有超过两列的DataTable值绑定到combobox，并有"请选择"或"全部"选择项

最新推荐文章于 2020-11-21 22:51:58 发布

真爱无限

最新推荐文章于 2020-11-21 22:51:58 发布

阅读量4.6k

点赞数

分类专栏： C#/.NET/VS/Linq 文章标签： winform string null

本文链接：https://blog.csdn.net/pukuimin1226/article/details/7787491

版权

C#/.NET/VS/Linq 专栏收录该内容

123 篇文章 3 订阅

订阅专栏

        #region 显示多列DataTable到combobox
        /// <summary>
        /// 显示多列DataTable到combobox
        /// </summary>
        /// <param name="dataTable">含有超过两列的DataTable</param>
        /// <param name="comboBox">combobox控件名</param>
        /// <param name="TextColumn">显示的text对应的列</param>
        /// <param name="ValueColumn">value值对应的列</param>
        /// <param name="isNeedShowEmpty">是否显示‘请选择’</param>
        /// <param name="isNeedShowAll">是否显示‘全部’</param>
        public static void ToDataTableCombobox(DataTable dataTable, ComboBox comboBox, string TextColumn, string ValueColumn, bool isNeedShowEmpty, bool isNeedShowAll)
        {
            if (dataTable == null || comboBox == null || dataTable.Columns.Count == 0)
            {
                return;
            }
            DataTable dtnew = new DataTable();
            dtnew.Columns.Add("text");
            dtnew.Columns.Add("value");
            if (isNeedShowEmpty)
            {
                DataRow emptyRow = dtnew.NewRow();
                emptyRow[1] = "";
                emptyRow[0] = "--请选择--";
                dtnew.Rows.InsertAt(emptyRow, 0);
            }
            else if (isNeedShowAll)
            {
                DataRow emptyRow = dtnew.NewRow();
                emptyRow[1] = "";
                emptyRow[0] = "全部";
                dtnew.Rows.InsertAt(emptyRow, 0);
            }
            for (int i = 0; i < dataTable.Rows.Count; i++)
            {
                DataRow dr = dtnew.NewRow();
                dr["text"] = dataTable.Rows[i][TextColumn];
                dr["value"] = dataTable.Rows[i][ValueColumn];
                dtnew.Rows.Add(dr);
            }

            comboBox.DataSource = dtnew;//GetItemList()
            comboBox.DisplayMember = dtnew.Columns[0].ColumnName;//"text";
            comboBox.ValueMember = dtnew.Columns[1].ColumnName; //"value";
        }
        #endregion