autocompletecustomsource c#

Question

Hi all, Currently I have a combobox that is all working and i can search it by typing in order from the start, but if i wanted to search later in the string, for example, lastname instead of typing the firstname first, it will not search the box, i believe its something to do with needing a customautocomplete source, but i cant get that to work with my code..
any help?

// On form load, connect to DB and get the contact list

            string MyConString = "SERVER=192.168.0.89;" +

                "DATABASE=sms;" +

                "UID=user;" +

                "PASSWORD=password;";

            

            MySqlConnection connection = new MySqlConnection(MyConString);

            

            string command = "select name,number from pbk";

            

            MySqlDataAdapter da = new MySqlDataAdapter(command, connection);

            

            DataTable dt = new DataTable();

            

            da.Fill(dt);

            // Fill the contact list dropdown

            foreach (DataRow row in dt.Rows)

            {

                string rows = string.Format("{0}:{1}", row.ItemArray[0], row.ItemArray[1]);

                

                comboBox1.Items.Add(rows);

            }

            connection.Close();