Loading

autosuggestion in textbox from sqlserver 2005

selva kumar

when i type a letter 'A' it must display all related word in textbox from database.....plz help me

the code i attached is working but its not displaying the last word in database for example if i'm having words like selva,selvi,selvakumar,senna... if i type 'S' its suggesting only first three words its not displaying last word 'senna'.... could you solve my problem....

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Santhosh Kumar Jayaraman14y ago
I am not sure why you face this issue, Make sure the records exists and query it first in database. I run ur code with my values and its working fine. Check my attached image
0
Nitesh Kejriwal14y ago
Are you sure, it is not displaying the last record only? I notice you are using the keyword DISTINCT in your query that means the last record "senna" must be present in some other record and hence it is not shown. I tested at my end and it worked perfectly Ok.
0