Multi Column Autocomplete ComboBox in C#

Submitted by janobe on Friday, September 28, 2018 - 15:32.

In this tutorial, I will teach you how to autocomplete a combobox with multiple columns in c#. This method has the ability to auto suggest and append a combobox with different columns from the datatable. See the procedure below.

Creating Database

Create a database named “test”.

Create database test

Create a table in the database that you have created.

CREATE TABLE `tblperson` (
  `PersonID` int(11) NOT NULL,
  `Fname` varchar(90) NOT NULL,
  `Lname` varchar(90) NOT NULL,
  `Mname` varchar(90) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Insert the data in the table.

 
INSERT INTO `tblperson` (`PersonID`, `Fname`, `Lname`, `Mname`) VALUES
(1, 'Janno', 'Palacios', 'E'),
(2, 'John Craig', 'Nillos', 'P'); 

Creating Application.

Step 1

Open Microsoft Visual Studio 2015 and create a new windows form application. auto12

Step 2

Add a ComboBox in the form. auto213

Step 3

Double click the form to fire the code view and add the following code for your imports to access MySQL library.

using MySql.Data.MySqlClient;

Step 4

Create a connection between C# and MySQL database. After that, declare all the classes that are needed.

  
        MySqlConnection con = new MySqlConnection("server=localhost;user id=root;password=janobe;database=test;sslMode=none");
        MySqlCommand cmd;
        MySqlDataAdapter da;
        DataTable dt;
        string sql;

Step 5

Create a method for autocomplete combobox.

public void autocomplete()
        {
            try
            {
                sql = "SELECT * FROM tblperson";
                con.Open();
                cmd = new MySqlCommand();
                cmd.Connection = con;
                cmd.CommandText = sql;
                da = new MySqlDataAdapter();
                da.SelectCommand = cmd;
                dt = new DataTable();
                da.Fill(dt);
 
                int maxcolumn = dt.Columns.Count - 1;
                
                foreach(DataRow row in dt.Rows)
                {
                    for (int i = 0; i < maxcolumn; i++)
                    {  
                        comboBox1.AutoCompleteCustomSource.Add(row.Field<string>("Fname"));
                        comboBox1.AutoCompleteCustomSource.Add(row.Field<string>("Lname"));
                        comboBox1.AutoCompleteCustomSource.Add(row.Field<string>("Mname"));
                    }
 
                }
                 
 
            }

Step 6

Call the method that you have created and set it in the first load of the form.

        private void Form1_Load(object sender, EventArgs e)
        {
            autocomplete();
        }

For any questions about this article. You can contact me @ Email – [email protected] Mobile No. – 09305235027 – TNT FB Account – https://www.facebook.com/onnaj.soicalap

Add new comment

818 views