c# Autocomplete more than one field

[ph1l]

Hi all,

I have an app im working on that stores details of employees that users can then go back and search through.

I have an autocompleting combobox that searches through the surname, but if i make the first name box autocomplete, it searches the entire table not just first names relating to the surname already entered.

I understand why it does this, but im stuggling to figure out how to link it to the surname box.

Can anyone give me any pointers? Im a bit of a newbie, so apologies in advance!

Thanks

[nateraaaa]

Hi all,

I have an app im working on that stores details of employees that users can then go back and search through.

I have an autocompleting combobox that searches through the surname, but if i make the first name box autocomplete, it searches the entire table not just first names relating to the surname already entered.

I understand why it does this, but im stuggling to figure out how to link it to the surname box.

Can anyone give me any pointers? Im a bit of a newbie, so apologies in advance!

Thanks

If you are using Visual Studio 2005 or higher then you could utilize the AutoComplete extender that comes with the AJAX control toolkit. You can find out more about this control and other AJAX controls here .

Nathan

[ph1l]

If you are using Visual Studio 2005 or higher then you could utilize the AutoComplete extender that comes with the AJAX control toolkit. You can find out more about this control and other AJAX controls here .

Nathan

Apologies for not making it clear, im developing a windows app not a web app and as far as i can see the AJAX controls are for the web only. Is there an equivalent for windows apps or any other ideas?

Thanks for your help

[Capetown]

If I understand your question,

You can build a second AutocompleteList for the first names of the surnames but this time, fill the list by first filtering through the surname that was chosen.

Your SELECT statement would look something like: SqlCommand.CommandText = "SELECT Name FROM Employee WHERE Surname = ' " + ComboBox.Text + " ' "; // Or whatever textbox you are using.

This based on using a database and not a textfile, and a column for the firstname and the surname seperately.

After that it is the same process to populate the Firstname ComboBox with the Autocomplete as it was for the Surname ComboBox.

Hope that helps!