search user on multiple selection

Question

0.00/5 (No votes)

See more:

I am working with a small application and I want to filter all the customer on multiple conditions such as dob, order, advance. I'm using where condition. It is not working very well. I want if I enter DOB then display all the customer according to DOB if i enter all the 3 option then search all the condition like google Advanced Search.

Posted 19-Jan-11 23:08pm

c27bharti

Updated 19-Jan-11 23:17pm

#realJSOP

v2

Add a Solution

4 solutions

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)

Blesson Mathew · Answer 1 · 2011-01-20T00:09:00

hi
Here i am giving you one example

SQL

declare @name varchar(100)='b',
@dob date='2010-12-10'


if(@name  is null and @dob is null)
BEGIN
    select * from tblUsers
    END
    else if(@name is not null and @dob is null)
    BEGIN
    select * from tblUsers where tblUsers.strFirstName like @name+'%'
    END
    else if(@name is null and @dob is not null)
    BEGIN
    select * from tblUsers where tblUsers.dateDateOfBirth=@dob
    END
    else
    BEGIN
        select * from tblUsers where tblUsers.strFirstName like @name+'%' and tblUsers.dateDateOfBirth=@dob
        END

I hope this idea may help you

Ankur^\m/ · Answer 2 · 2011-01-19T23:52:00

Solution 3

This forum discusses the same thing: http://forums.asp.net/t/1381718.aspx[^]

I hope this helps!

Posted 19-Jan-11 23:52pm

Ankur^\m/

Comments

Sandeep Mewara 21-Jan-11 0:56am

Good link!

Ankur^\m/ 21-Jan-11 1:01am

Thanks Sandeep!

Hiren solanki · Answer 3 · 2011-01-19T23:25:00

Solution 1

Sharing your query can give us little idea towards but I think you aren't putting condition well with AND and OR.

See THIS[^] my answer will guide you towards if you are making any mistake with condition.

Please share your code too.

Posted 19-Jan-11 23:25pm

Hiren solanki

Comments

Ankur^\m/ 21-Jan-11 0:06am

I don't know what's the problem with you Hiren. You are ready for 5 votes for you good answers but why don't you accept down votes. Read the question again and then read your answer. It nowhere answers the question. Still I didn't gave you a 1.
All answers here except yours answers the question. The link that I have given answers it the best. Thanks for your 1 vote, I will remember that.

Hiren solanki 21-Jan-11 0:31am

I haven't voted you down. Sorry.

Ankur^\m/ 21-Jan-11 0:35am

A platinum authority member has voted it down. I am quite regular here and know people very well. Anyways thank you for replying.

Hiren solanki 21-Jan-11 0:44am

How much point it deducted from you ?

soni uma · Answer 4 · 2011-01-19T23:33:00

Following are sample procedure code. You have to make your own code from this sample.

SQL

CREATE PROCEDURE [dbo].[usp_Get_Procedure_Name]
(
   @dob date,
   @order int
)
AS
BEGIN
declare @strSql1 nvarchar(4000)
set @strSql1 = 'Select * from table tb where 1=1'
if @dob is not null
begin
set @strSql1 = @strSql1 + ' and tb.date between '+@dob+''
end
if @order <> 0
begin
set @strSql1 = @strSql1 + ' and  tb.order = '+CAST(@order as varchar(20))+''
end
exec sp_executesql @strSql1
END

search user on multiple selection

4 solutions

Solution 4

Solution 3

Solution 1

Solution 2

Add your solution here

Preview 0