select with and condition in asp.net

Question

0.00/5 (No votes)

See more:

i have database like

VB

id=1111 and fighi="1AoHere"

id=3333 and fighi="3AoHere"

id=1111 and fighi="12AoHere"

idl=3333 and fighi="32AoHere"

id=1111 and fighi="11AoHere"

id=3333 and fighi="31AoHere"

id=11121 and fighi="12AoHere"

idl=33332 and fighi="32AoHere"

in datatable

i want to use select query for datatable to get below for query (select id='1111' and id='2222')

VB

1AoHere,12AoHere,11AoHere  all these for id=1111

3AoHere,32AoHere,31AoHere  all these for id =3333

Posted 2-Jan-14 22:49pm

maulikshah1990

Add a Solution

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

OriginalGriff · Answer 1 · 2014-01-02T23:00:00

Solution 1

Try this:

SQL

SELECT Id, fighi=
   STUFF((SELECT ',' + CONVERT(VarChar(10), fighi)
      FROM MyTable b
      WHERE b.Id = a.lId
      FOR XML PATH('')), 1, 1, '')
FROM MyTable a
WHERE Id IN (1111, 3333)
GROUP BY Id

Posted 2-Jan-14 23:00pm

OriginalGriff

Comments

maulikshah1990 3-Jan-14 5:02am

how to use above in asp.net , and in datatable

pls give code example

OriginalGriff 3-Jan-14 5:07am

Use that as your select query, and it will fill the DataTable.

maulikshah1990 3-Jan-14 5:13am

1AoHere,12AoHere,11AoHere all these for id=1111

3AoHere,32AoHere,31AoHere all these for id =3333
the above two was just to explain you..

i want values in.. select

exp.: if i want fighi for id=1111 and id=3333 ..what is select query from datatable in asp.net

OriginalGriff 3-Jan-14 5:21am

Sorry, we seem to be talking at cross purposes here - From what I read of your question the query does exactly what you are asking for - so where is the confusion between us?
Did you try the select? What did it return, and what did you expect it to return?

maulikshah1990 3-Jan-14 5:29am

forgot everything from before question..
below is what i need to do

i have records in database as

hotelid amenitieid
11123 25253
25361 24452
47458 25253
74852 15236
96585 25253
65923 25253
84664 15236
12321 15236

now from above, if i want hotelid where amenitieid = 25253 and amenitieid =15236 , and not any other hotelid , then what is query in asp.net datatable ...

what too use in datatable.select (amenitieid='15236' and amenitieid='25253');

i hope this is clear ....

OriginalGriff 3-Jan-14 5:35am

Didn't we go round this yesterday?

maulikshah1990 3-Jan-14 5:37am

but i dont get any answer .......give solution...again properly ..

maulikshah1990 3-Jan-14 6:10am

ok..how to use

SELECT HotelId FROM Amenities
WHERE Amenitieid=719 OR Amenitieid=603
GROUP BY HotelId
HAVING COUNT(*) = 2

in datatable select with where clause values from foreach ()

thatraja · Answer 2 · 2014-01-02T23:12:00

Solution 2

Use Datatable.Select[^] or Dataview.RowFilter[^]

Posted 2-Jan-14 23:12pm

thatraja

Maciej Los · Answer 3 · 2014-01-02T23:22:00

Solution 3

Use thise:

SQL

SELECT ID, FIGHI
FROM TableName
WHERE ID IN (111, 333)

or

SQL

SELECT ID, FIGHI
FROM TableName
WHERE (ID =111) OR (ID =333)

You can't use AND operator with WHERE statement, because ID can't be equal to 111 and 333 at the same time. It can be equal 111 or 333.

Posted 2-Jan-14 23:22pm

Maciej Los