C#•3y ago

❔ Implementation of Search page in ASP. NET MVC along with stored procedure

Can anyone help me to create a webform to search the data from the database to filter it on web page.

Let suppose the data is an Employee table or a product table. And I want an webpage by which I can search this data is available on the database or not?

l3pordOP•10/18/23, 3:57 PM

Consider this is the table

leo•10/18/23, 4:06 PM

ok i dont think i got it straight but i will literally say what i understood:

1# scenario (that i understood)

you want to create a page which lists your table (duh) BUT you want to list only the AVAILABLE ITEMS.

in that case you would need to add a new column there as boolean or int whatever suits better to you

you can call that column as isactive or something like that idk

and basically the items which has that column as 1 are the active ones and the ones that has it as 0 are the inactives (duh 2)

and your select query should look like this

select * from cooltablename ctn where ctn.isactive = 1

in case you are using ef/linq it should look like this

list.Where(x => x.isactive == true).ToList()

leo•10/18/23, 4:06 PM

if i got it wrong sorry im dumb

leo•10/18/23, 4:06 PM

now if you are looking on creating a search bar then thats a little more different

l3pordOP•10/18/23, 4:08 PM

Let me explain again.....)

leo•10/18/23, 4:08 PM

sure im all ears

l3pordOP•10/18/23, 4:08 PM

Consider the above table as that is Product table

l3pordOP•10/18/23, 4:10 PM

Refer to product table above and implement a Search page in ASP.MVC along with stored procedure in backend (db).
Please follow below points while developing solution for given requirement.

Search Criteria needs to be developed at both frontend & backend for following fields
a. ProductName
b. Size
c. Price
d. MfgDate
e. Category
UI should provide option to define search criteria using any combination of 1 or more fields specified in point 1.(i.e. Search criteria can be specified using 1 field, 2 field or all fields)
If two or more fields are used in search criteria then an option should be provided in UI to specify the conjunction between two conditions(i.e. AND , OR)
Also provide option to clear/reset the search criteria.
Show the Search results in grid/table in UI.
Develop the stored procedure that satisfies all the conditions provided by UI.

l3pordOP•10/18/23, 4:10 PM

Now I hope this is clear to you?

Lleo now if you are looking on creating a search bar then thats a little more differe...

leo•10/18/23, 4:10 PM

yeah i think now fits more with the second scenario that i got in mind

l3pordOP•10/18/23, 4:12 PM

Yeah

l3pordOP•10/18/23, 4:14 PM

What could be your second scenario

l3pordOP•10/18/23, 4:14 PM

I have created a controller

l3pordOP•10/18/23, 4:15 PM

and Model

l3pordOP•10/18/23, 4:18 PM

Product_Table.sql842B

Stored_Procedure.sql474B

3R1C•10/18/23, 4:25 PM

I understand you might enjoy doing what you're doing, but have you ever considered using code first?

leo•10/18/23, 4:26 PM

ok so rn i cant right anything to give as an example but you can do a search method using sql like function where you will receive a parameter as the word which the user will input in the ui and then you can search or filter through it, ik its not well explained but try that as a proof of concpet