hello, i want to create a search engine to my website in asp.net 2.0 but search in sql server database , does any one know a tutorial about it ? thanks for any help. Derin
Well,if you would like to search your DB for results thenyou have have to query your DB tables with several 'AND' and 'OR' conditions inthe WHERE clause and try using 'LIKE' conditionl operator along with wildcard charaters (A "%" sign can be used to define wildcards ). Sample Query : SELECT first_name ,last_name AS Name, SalesFROM sampleWHERE last_name LIKE'%strSearch%' OR first_name LIKE '%strSearch%' where strSearch is the searched keyword. Usually DB searches are fine if you have a small site or a small database.Otherwise I would suggest using the following searchtechniques: For non DB site search, See:http://www.developerfusion.co.uk/show/4389/ & http://www.codeproject.com/aspnet/SearchDotnet.asp Vikram DiscountASP.NET www.DiscountASP.NET
