help me with search code

luckyve

Hi friends. I am cearting my website ... I need "search" in a webform. for example, when the user types " demo " in the textbox of the search page, then it should appear all the things in all pages of the website,which is correlate with the word "demo". Just like the search in codeproject. how can I do it ? I just know about searching with a specific field,like user name,age,... but I dont have any idea about a word searching ... is there any articles which can help me? Or can anyone help me to write ...? thanks alot.:rose:

David Trasbo

Are you searching i a SQL Database? -- David Trasbo.

netJP12L

Put "Like" keyword in your select query and pass different parameters i.e syntax may not be write: Select * from Like="AAA",Like"BBB";

luckyve

Yes,Sorry I forgot to say.. My Database is SQLServer 2000 plz help

luckyve

netJP12L wrote:

Put "Like" keyword in your select query and pass different parameters i.e syntax may not be write: Select * from Like="AAA",Like"BBB";

sorry I didnt understand ... What does "like" do ?? What is "AAA" or "BBB" ...? I want this search form to work with any word...like codeporject's search ... plz help me

netJP12L

You need to set a criteria for how a particular thing will be searched out in your database. Like is a keyword that tells the query look for something that i am passing in the parameter. Like keyword is different than Equal or ==. As Obvisouly, equal mean look exactly what I need to search. SELECT * FROM QUESTION_PARENT WHERE (PTYPE LIKE 'searchCriteria')