Search record by name in sql server.

Accepted answer

Hi,

Try below query -

SELECT * FROM tablename WHERE name LIKE '%a%' ORDER BY name asc

+1

there are many method in asp.net c#,

I think you want search in dropdown ,then no need to change your sql query.

firstly select all data and bind in dropdown and then use jquery to search item from dropdown according your typing word.

otherwise you can use autocomplete textbox logic.

visit here

https://bikeshsrivastava.blogspot.in/2016/07/part-25how-to-implement-auto-complete.html

+1

follow below url it me be help you

http://www.w3schools.com/Sql/trysql.asp?filename=trysql_select_like_pattern