winform: 设置下拉框数据源的公共函数

最新推荐文章于 2022-09-11 15:31:20 发布

iteye_14050

最新推荐文章于 2022-09-11 15:31:20 发布

阅读量121

点赞数

本文详细介绍了如何使用 C# 设置 DevExpress ComboBox 控件的下拉框参数，包括查询 SQL、数据源、预设文本和可编辑性设置。

// 设置下拉框传入参数(需要设置的下拉框控件，查询的语句，默认第一行的内容) public static void SetComboList(DevExpress.XtraEditors.ComboBoxEdit ComboList, string QuerySQL, ArrayList arrSource = null, DataTable dtSource = null, string FirstRowText = "", bool bSelectFirstItem = false, bool bEditable = false) { DataTable dtList = null; if (dtSource != null) { dtList = dtSource; } else if (arrSource != null) { dtList = new DataTable(); dtList.Columns.Add("name"); foreach (string s in arrSource) { dtList.Rows.Add(s); } } else if (!string.IsNullOrEmpty(QuerySQL)) { try { dtList = SqlHelper.ExecuteDataTable(SqlHelper.ConnString, CommandType.Text, QuerySQL, null); } catch (Exception ex) { Common.DisplayMsg("数据访问异常:", ex.Message.ToString()); return; } } else { return; } int intCount = (dtList != null) ? dtList.Rows.Count : 0; if (bEditable) { ComboList.Properties.TextEditStyle = TextEditStyles.Standard; } else { ComboList.Properties.TextEditStyle = TextEditStyles.DisableTextEditor; // 设置 comboBox的文本值不能被编辑 } ComboList.Properties.Items.Clear(); if (!string.IsNullOrEmpty(FirstRowText)) ComboList.Properties.Items.Add(FirstRowText); if (intCount > 0) { for (int i = 0; i < intCount; i++) { ComboList.Properties.Items.Add(dtList.Rows[i][0].ToString()); } } if (bSelectFirstItem) ComboList.SelectedIndex = 0; // 设置选中第1项 }