c# - How to fetch entries starting with the given string from a SQL Server database? -
I have a large number of words used in a tag system, I need the code for an autocomplete box But I am not sure how to bring entries that match the database to the most efficient way.
I have a command of choice, but it seems I am more than a similar order. I get only words which I look like the word.
My plan is to read every line, and then use the string of C #. Wires () and string. () Is fit, but I think with a large database, it may be disabled to read every line and then filter them.
Is there a way to read only those lines that start with SQL Server or have a string in it? When using such as
, you provide a% symbol as a wildcard. If you want strings that start with Hello, you will use 'Hello%', if you wanted a string with Hello in anywhere in the string, you would use it as '% Hello%'
For efficiency, like optimal you should look at full text search.
Comments
Post a Comment