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
Thank u Will it show bad performance on my application,because on every key up event this process will be invoked is this the right procedure normally people chosse to search
It will not be as fast as the original query because the query can not optimize an index to use. Depending on the number of records, the end result can vary from 1/10th of a second to several second.
select query in .NET for Searching
Posted - 11/08/2006 : 00:39:50
