auto lookup

[Yogeetarp]

Hello,

I have an excel sheet with a bunch of activities and their respective codes assigned to it.

Now I want to create a lookup table that would do the following:

If a user types in some words it should lookup in the spreadsheet for ALL the matching words and populate them on the screen with a list. The user can then select the entry from the list and it will give the mathing code.

Implementation:

I was thinking about a combobox with simple style. So when I dynamically update the list, it would be searching and changing the combobox list dynamically on each keypress. That's just a thought, to implement that I am a little confused.

Maybe I was thinking about setting an array as the datasource of combobox and then update that array dynamically by searching through the column of the datasheet. This would change the combobox list too. But now doing that on each keypress would be too much time consuming, right? Should I rather create a textbox and a listBox and have a button that marks the end of the typing, and then I can parse the string and then search through the table?

Is there any sort of functionality available on web to do this already?

If I am not clear on my question, please let me know. Any suggestions would be a great help.
-Thanks

 

[tperri]

Use AJAX as your solution to this problem

 

[Yogeetarp]

Thanks for the response. I am doing this application as a windows form and not web form, so I don't think AJAX would help.

Thanks.

 

[tperri]

I don't see why you couldnt still call a web service to help with it on a windows form