I'm following up on an ASP.Net MVC application and I need to do a search screen.
The question is as follows:
I created a table where users register their skills.
I need a
view where there will be a text field where the person will type for example: "Sewing". Click fetch and the application should return all users who have the word "Sewing" inside the table skills field.
How to implement this?
It's like these search fields that we have on every site. I think it's pretty simple, but I do not know where to start.
I would like in the controller to make a
select ... where... like '%@PALAVRADIGITADA%' only that I do not know the syntax to pass this variable and such.
If anyone can give me a light, thank you in advance.