PDA

Click to See Complete Forum and Search --> : lookup table


lis
Jan 13th, 2005, 02:26 AM
Hi All,

I want to search for usernames . I want to use a lookup table for searching all names as I type each word.

Example:

If I type the letter A, it should display all names in the lookup table beginning with A. And when I type An it should give all names with An(like Andrew, Ann,etc).

The lookup table should also give me the user ID. ( database has a table which has the username and userID, both these values should be returned when seacrching for the username)


Please show an example in Vb.NET or give me a link which has a similar solution



Thanks and regards,
lis

plenderj
Jan 13th, 2005, 03:15 AM
So this is going to be posting back live data as the user types?

lis
Jan 13th, 2005, 03:30 AM
s it will get back data that exists on the database.

Like I mentioned I have a database with the fields UserName and UserID. On typing a few letters of the name , both username and UserId should be displayed so that i can select the user from the lookup table.

plenderj
Jan 13th, 2005, 03:51 AM
Okay, displayed where...? In a table below the textbox or in an IFRAME or something?

lis
Jan 13th, 2005, 04:11 AM
It should be displayed in a table (lookup table) something like a data grid (more like a popup only when for the search).

lis
Jan 15th, 2005, 12:13 AM
An example will be enough. Something in VB.NET which i can use for my application.