Textbox AutoComplete using LIKE rather than START
Posted on 2012-03-15
I'm trying to find a simple (i'm a beginner) solution or pointers as to how i can modify the AutoComplete on a textbox so that it searches the whole string rather than the start i.e. using a sql LIKE equivalant.
I've created the textbox, set the AutoCompleteMode = Suggest, AutoCompleteSource = CustomSource and the AutoCompleteCustomSource to a AutoCompleteStringCollection() that i have already populated.
It all works as expected but now I would like to modify or override something so that it will return values from mid string. I've searched all over to no avail.
Thanks in advance...