HOW DO I CREATE A SEARCH ENGINE FOR MY WEBSITE USING ASP.NET C#?

I am trying to search a SQL Server 2008 database table based on user input into a texbox. I have already tried using the clause LIKE ‘%x%’, but it’s not useful when the user types in multiple words. I want my search engine to be able search keywords in the database. I read about FREETEXT and CONTAINS, but im not sure if that will work.
Please help me..Thanks in Advance.
about 1 year ago
The easiest way is to use the FREETEXT clause because it does not require a specifc format. The CONTAINS keyword allows you to use search limiters such as “AND NOT”. You will however need to create a full-text index on the table/columns you want to search.
Where are you outputting your results to? I’m assuming a .net webpage. If so you could simply just split your search string into parts. Use the ‘%LIKE%’ syntax for each separate word and then merge the results if you stored them in datatables by simply calling the Merge method of a datatable.