How do I create a search box in my ASP.net application that uses a SQL query that has the capability to search with more than one keyword?

Answer 1

Create a text box object. In the back end, assign the input from the textbox to a variable.

On the database (assuming you're using MSSQL) create a stored procedure ready to accept a string. In the stored procedure, put whatever logic you'd like to search for using the parameter provided by the variable (from the text box). Have the stored procedure respond.

In the back end, have another variable accept the response from the stored procedure. To do so, you will want to create a function which takes a parameter (the input from the text box), calls the stored procedure, and then shoot back the response from the stored procedure.

Helpful hint: back when I would program in VB.NET, there was a library name "sqlhelper" which made connecting to the database easier.