Combo Box to search for any word contains then list

Hello All,

I need to make searchable comobox to autocomplete with any word matches in the column.

how to code search any word from the data table specific column instead searching from begining..

Excel file contains value as below.,

Mohan Raj

Raj Kumar

Raj Kiran

Ganesh Kumar

Outout Required as below

when combobox typed raj, auto complete should suggest all the name under raj.

Datatable created from excel file.

please guide me how to achive this searchable option..

Hey try this.

using System;
using System.Data;
using System.Windows.Forms;
namespace Notification
{
public partial class AutoCompleteComboBox : Form
{
public AutoCompleteComboBox()
{
InitializeComponent();
}
private void AutoCompleteComboBox_Load(object sender, EventArgs e)
{
FillComboBox(cmbAutoComplete);
cmbAutoComplete.AutoCompleteMode = AutoCompleteMode.Suggest;
cmbAutoComplete.AutoCompleteSource = AutoCompleteSource.CustomSource;
AutoCompleteStringCollection combData = new AutoCompleteStringCollection();
GetComboBoxData(combData);
cmbAutoComplete.AutoCompleteCustomSource = combData;
}
private void FillComboBox(ComboBox cmbComboBox)
{
DataTable dtData = GetData();
cmbComboBox.DataSource = dtData;
cmbComboBox.ValueMember = "CID";
cmbComboBox.DisplayMember = "CNAME";
}
private void GetComboBoxData(AutoCompleteStringCollection dataCollection)
{
DataTable dtData = GetData();
foreach (DataRow row in dtData.Rows)
{
dataCollection.Add(row[1].ToString());
}
}
private DataTable GetData()
{
// Here you can write your code to get data from excel or database
DataTable dtData = new DataTable();
dtData.Columns.Add("CID", typeof(int));
dtData.Columns.Add("CNAME", typeof(string));
dtData.Rows.Add(1, "Amit Mohanty");
dtData.Rows.Add(2, "Abinash Hota");
dtData.Rows.Add(3, "Swarup Pradhan");
dtData.Rows.Add(4, "Manas Satpathy");
dtData.Rows.Add(5, "Alok Panda");
dtData.Rows.Add(6, "Rabi Hota");
dtData.Rows.Add(7, "Sudam Biswal");
dtData.Rows.Add(8, "Sudhir Mishra");
return dtData;
}
}
}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Mohanty7y ago
Hey try this.
using System;
using System.Data;
using System.Windows.Forms;

namespace Notification
{
    public partial class AutoCompleteComboBox : Form
    {
        public AutoCompleteComboBox()
        {
            InitializeComponent();
        }

        private void AutoCompleteComboBox_Load(object sender, EventArgs e)
        {
            FillComboBox(cmbAutoComplete);
            cmbAutoComplete.AutoCompleteMode = AutoCompleteMode.Suggest;
            cmbAutoComplete.AutoCompleteSource = AutoCompleteSource.CustomSource;
            AutoCompleteStringCollection combData = new AutoCompleteStringCollection();
            GetComboBoxData(combData);
            cmbAutoComplete.AutoCompleteCustomSource = combData;
        }

        private void FillComboBox(ComboBox cmbComboBox)
        {
            DataTable dtData = GetData();
            cmbComboBox.DataSource = dtData;
            cmbComboBox.ValueMember = "CID";
            cmbComboBox.DisplayMember = "CNAME";
        }

        private void GetComboBoxData(AutoCompleteStringCollection dataCollection)
        {
            DataTable dtData = GetData();
            foreach (DataRow row in dtData.Rows)
            {
                dataCollection.Add(row[1].ToString());
            }
        }

        private DataTable GetData()
        {
            // Here you can write your code to get data from excel or database
            DataTable dtData = new DataTable();
            dtData.Columns.Add("CID", typeof(int));
            dtData.Columns.Add("CNAME", typeof(string));

            dtData.Rows.Add(1, "Amit Mohanty");
            dtData.Rows.Add(2, "Abinash Hota");
            dtData.Rows.Add(3, "Swarup Pradhan");
            dtData.Rows.Add(4, "Manas Satpathy");
            dtData.Rows.Add(5, "Alok Panda");
            dtData.Rows.Add(6, "Rabi Hota");
            dtData.Rows.Add(7, "Sudam Biswal");
            dtData.Rows.Add(8, "Sudhir Mishra");

            return dtData;
        }
    }
}
+1
Amit Gupta7y ago
You can use rowFilter property of DataTable DataView dv = new DataView(yourDatatable); dv.RowFilter = string.Format("Name = '%{0}%'", combobox.Text);
+2
archana devi7y ago
Hi,
Check the following article "Combo box in c#"
https://www.c-sharpcorner.com/uploadfile/mahesh/combobox-in-C-Sharp/
and "Combo box with search and suggest list"
https://www.codeproject.com/Tips/789705/Create-combobox-with-search-and-suggest-list

hope it helps you
+1