Now i need to Search the books according to user interest if user selects the SEARCH BY NAME and(also some Categeory) option to search. i wrote command like this
select * from Books Where BookCategeory='Education' and BookName like 'sometext%'
in key_up event of TextBOX
is this is the right way to search if there are more no of records will it disgrade performance because for every key press it will communicate with database how far it is better or I need to go for other