Here is my code but its work only first word..
dbcon.Open(); try { AutoCompleteStringCollection pAuto = new AutoCompleteStringCollection(); string query = "SELECT DISTINCT FullDescription FROM ProductInfo WHERE FullDescription LIKE '%'+@pattern+'%'"; SqlCommand cmd = new SqlCommand(query, dbcon); cmd.Parameters.AddWithValue("@pattern", '%'+txtProductGroup.Text+'%'); // dbcon.Open(); SqlDataReader Contains = cmd.ExecuteReader(); AutoCompleteStringCollection autoCompleteList = new AutoCompleteStringCollection(); while (Contains.Read()) { autoCompleteList.Add(Contains["FullDescription"].ToString()); } txtProductGroup.AutoCompleteCustomSource = autoCompleteList; Contains.Close(); // dbcon.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } dbcon.Close();