C# : textBox control

[Guest]

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 charactere EXEMPLE "R" in textbox interface, I have all list
of words that start with this charactere : REPUBLIQUE FRANCE , REPUBLIQUE
GERMANY
but I have not the rest of word that start with first character to locate
in any place EXEMPLE I HAVE NOT : MAROC REPUBLIQUE
WHEREAS MAROC REPUBLIQUE existe in my collection
please help my

 

[Guest]

That is basically how it is supposed to work, much like the autocomplete
functionality of Internet Explorer in the address bar. The functionality
you're looking for must be custom coded, or perhaps a third-party control
will help you?