ArrayList allmodels;
        public ArrayList GetAllModels()
        {
            allmodels = new ArrayList();
            using (SqlConnection con = new SqlConnection(connection))
            {
                SqlCommand com = new SqlCommand("SELECT [Model], [YearOfIssue], [Season] FROM Model Order By Model", con);
                try
                {
                    con.Open();
                    SqlDataReader dr = com.ExecuteReader();
                    if (dr.HasRows)
                        foreach (DbDataRecord result in dr)
                        {
                            allmodels.Add(result);
                        }

                }
                catch { }
            }
            return allmodels;
        }

string query = string.Format("SELECT *  FROM Model WHERE [Model]  LIKE  '%{0}%' ", searchText);