how to match data in SQL query

Question

0.00/5 (No votes)

See more:

Hi all

I have to populate a GridView from a Table in Database. I was populating it by following query (which was ok).

SQL

SELECT * FROM EmailTable WHERE empno IN(Select EmpNo from RetiredEmployees) AND disable IS NULL AND deleted IS NULL.

Now my boss said that you are supposed to make a WebService of RetiredEmployees which will return an Array of RetiredEmployees.

So I made it accordingly, now the problem is how I cross match EmpNo in ArrayList in SQL statement.

SQL

SELECT * FROM EmailTable WHERE empno IN(Select EmpNo from RetiredEmployees(Service ArrayList)) AND disable IS NULL AND deleted IS NULL.

thanks in advance

Posted 6-Aug-12 21:10pm

hunerajamshed

Add a Solution

Comments

ZurdoDev 7-Aug-12 8:24am

SQL can't handle the arrays, as far as I know. You'll have to do some code to convert the array into a string so that you end up with something like "SELECT EmpNo from RetiredEmployees WHERE EmpNo IN ('Employee1','Employee2','etc'))

2 solutions

Solution 1

You have a couple of options, see here[^].

I personally favor using XML, but you'd wand to find the best solution that fits your situation.

Posted 7-Aug-12 9:16am

Andrew Rissing

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)

hunerajamshed · Accepted Answer · 2012-08-08T22:03:00

Solution 2

thanks for replying Andrew

I resolved it myself with an easy way. I converted array values into CSV, which generated a long messy string. I put that string object into SQL, it seems working fine but any other idea will be appreciated.

thanks again,

Posted 8-Aug-12 22:03pm

hunerajamshed