ComboBox实现模糊查询
1.实现前提是ComboBox的下拉框数据必须是List列表形式;
2.实现模糊查询只需要更改ComboBox的comboBoxnum_TextUpdate事件。
下面是详细实现过程
1.双击进入ComboBox的TextUpdate事件
2.附代码
//全局变量
List<string> listOnit = new List<string>();
List<string> listNew = new List<string>();
/// <summary>
/// comboxnum加载数据
/// </summary>
private void LoadComboxNum()
{
try
{
DataSet dstnum = new DataSet();
dstnum = searchOp.GetStockInMainNum();
//将从数据库查询到的数据写入List
foreach (DataRow row in dstnum.Tables[0].Rows)
{
listOnit.Add(row[0].ToString());
}
this.comboBoxnum.Items.AddRange(listOnit.ToArray());
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "警告", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
}
//TextUpdate事件代码
private void comboBoxnum_TextUpdate(object sender, EventArgs e)
{
this.comboBoxnum.Items.Clear();
listNew.Clear();
foreach (var item in listOnit)
{
if (item.Contains(this.comboBoxnum.Text))
{
listNew.Add(item);
}
}
this.comboBoxnum.Items.AddRange(listNew.ToArray());
this.comboBoxnum.SelectionStart = this.comboBoxnum.Text.Length;
Cursor = Cursors.Default;
this.comboBoxnum.DroppedDown = true;
}`