Click here to Skip to main content
15,940,550 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I am creating a real estate website and need to provide filters to property listing page as are in like e-commerce sites.
how to achive this please guide me or proide some links.[^]

here you can find the working example.


1 solution

I think you need to learn from basics. To achieve the same you need to use Where Clause of SQL Server[^]. There is nothing special in that.

See SQL for Beginners: Filtering Your Data[^].

A video tutorial Mastering ASP.NET GridView: Filtering and Multiple Checkboxes[^] would be enough to understand the concept of it.

Share this answer
Vinay1337 1-Aug-14 3:15am    
thanx amy but my cocern is not at sql level.
but want to know about how to manage the state in application.

and do i always need to use if to match conditions how many querystrings have the data and all that.
_Amy 1-Aug-14 3:21am    
You can build your query based on selected checkbox and then you can execute it in DB to get the filtered data.
Vinay1337 1-Aug-14 3:37am    
do i need to pass all teh data to querystring or can retrieve it directly from controls.
_Amy 1-Aug-14 4:09am    
Directly you can send the filter options to your SP. Then build a search query there and execute it for results.
Vinay1337 1-Aug-14 7:23am    
ok thanx _Amy

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900