autosuggestion in textbox from sqlserver 2005

Question

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....

Santhosh Kumar Jayaraman · Answer

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

Nitesh Luharuka · Answer

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.