search result filter by price...

Question

1.00/5 (1 vote)

See more:

Hi,

i need sql query or C# for search result filter by price like e-comm websites. many shopping websites will have price filter.

example:

0 - 250
250 - 500
500 - 750
750 - above

i need sql query or C# query for this above example. if user click on any price that related product has to display.

Posted 19-Apr-15 8:09am

Mohan Subramanian

Add a Solution

Comments

Sascha Lefèvre 19-Apr-15 14:29pm

Have you even tried to do it yourself?

Mohan Subramanian 19-Apr-15 14:31pm

i don't have idea for how to start it.

Sascha Lefèvre 19-Apr-15 15:18pm

Did you take a look at the documentation for the SELECT-keyword of SQL-Server ?

PIEBALDconsult 19-Apr-15 14:47pm

You will likely want to use BETWEEN.

Maciej Los 19-Apr-15 16:44pm

"I need..." is not a question at all! What have you tried till now? Where are you stuck?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Dev O'Connor · Accepted Answer · 2015-04-19T09:30:00

Solution 1

Hi Mohan

Here is a useful link for looking up SELECT on SQL.

MSDN: Expand SELECT Examples (Transact-SQL)

To give you a head start see SQL here:

SQL

SELECT * FROM MyTable
    WHERE ([PriceColumn] Between 0 And 250)
    ORDER By [PriceColumn] Asc

Posted 19-Apr-15 9:30am

Dev O'Connor

Comments

Maciej Los 19-Apr-15 16:46pm

+5

[no name] 8-May-15 4:04am

+5