[Solved] ASP.NET: How to create a search function just using a textbox? [closed]

Question

Since you didn’t provide any code here and asked for the directions, so here you go. Lets assume your TextBox name is ‘textBox1‘ and there is some button beside it. On the click event of that button you should be querying your database for the customer names that matches the text inside your ‘textBox1‘. The query which you would be using for your search would be something like:

SELECT * FROM Customers
WHERE CustomerName LIKE "%" + textBox1.text + "%"; //Assuming the table name is Customers

This should return all the customers who has textBox1.text inside their name. Hope this would give you some insight on where to start from. Cheers,,

Accepted Answer

Since you didn’t provide any code here and asked for the directions, so here you go. Lets assume your TextBox name is ‘textBox1‘ and there is some button beside it. On the click event of that button you should be querying your database for the customer names that matches the text inside your ‘textBox1‘. The query which you would be using for your search would be something like:

SELECT * FROM Customers
WHERE CustomerName LIKE "%" + textBox1.text + "%"; //Assuming the table name is Customers

This should return all the customers who has textBox1.text inside their name. Hope this would give you some insight on where to start from. Cheers,,