TextBox control

microsoft.public.dotnet.framework

15 Mar 2007 3:33 PM

mehdi

this my code :
string p = "REPUBLIQUE"
................
String SQl = @"select FEANME from st_cd_b where FEANME like'%" + p + "%'";
................
foreach (DataRow dr in table.Rows)
                   {
                       object[] tab = dr.ItemArray;
                       string s = Convert.ToString(tab[0]);
                   textBox1.AutoCompleteCustomSource.Add(s);

                     }
               }

if taping first caractere EXMPLE "R" in textbox interface, I have all liste
of words that start with this caractere : REPUBLIQUE FRANCE , REPUBLIQUE
GERMANY
but I have not the reste of word that start with first caracter to locate
in any place EXMPLE I HAVE NOT : MAROC REPUBLIQUE
WHEREAS MAROC REPUBLIQUE existe in my collection
please help my