can anybody please tell me how can i retrieve record from the database for a search Criteria.
I have Following records in the table
ID Name City
11 Arjun mumbai
12 Harry Delhi
13 Akhil Kolkatta
I have a textbox On Entering any name or phrase of name For Eg. if i Enter just ar then i should get Arjun and Harry(contains ar) Details in Gridview. If I enter full name arjun then I should get only Arjuns details in gridview.
To do this which SQL SELECT query i have to use..Tried Like,Contains and Exists. But could not get the desired result. Please help me in this regard.
View Complete Post