filter using and clause in asp.net listview

0.00/5 (No votes)

See more:

I have records like

Testid Checkid
1452 25853
3695 1475
2352 1365
2563 8596
3241 25853
4785 8596
3142 9874
1414 25853
1414 9874
3142 25853

I have all checbox with checkid
now when i click,checkid,25853, i want testid only for 25853 checkid
then i click 9874, i want Testid for checkid 25853 and 9874 (i want Testid which have both checkids)

so i this case,i should get 1414 Testid as result only
how to get that...

Posted 6-Jan-14 17:54pm

maulikshah1990

Add a Solution

Comments

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 7-Jan-14 0:16am

What have you tried and where is the problem?
And the requirement is not clear.

maulikshah1990 7-Jan-14 0:55am

i use dataset , and from above , i play mysql query as select * from above where checkid='25853' and checkid='9874'
this gives me 0 rows..
it should give me 1 record (row) i.e. 1414 Testid

maulikshah1990 7-Jan-14 1:26am

waiting...

maulikshah1990 7-Jan-14 4:19am

waiting

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

...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)

Last 24hrs

This month

OriginalGriff	130
Peter Klemm 2024	50
Pete O'Hanlon	15
George Swan	10
KarstenK	10

Pete O'Hanlon	1,765
OriginalGriff	1,507
Richard Deeming	560
Dave Kreskowiak	493
Richard MacCutchan	355