array in sql-where

darma teja

Hi,

I have a string array.
Example:

string[] test =new string[3] {"abc,def", "ghy,spd", "xyz,uni"};

How can put this array in sql where clause:

My final output query should like this:

Select *
from tableName
where id in ('abc', 'def', 'ghy', 'spd', 'xyz', 'uni');

Thanks,
Darma

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes12y ago
Accepted answer
If you're just wanting to build the query from the string array at this stage, then try this code:

using System;
using System.Text;

class Program
{
static void Main()
{
string[] test = new string[3] {"abc,def", "ghy,spd", "xyz,uni"};
StringBuilder sb = new StringBuilder();
foreach(string s in test)
{
string[] items = s.Split(',');
sb.Append(String.Format("'{0}', '{1}', ", items[0], items[1]));
}
sb.Length = sb.Length - 2; // get rid of trailing comma and space
string query = String.Format("Select * from tableName where id in ({0});", sb.ToString());
Console.WriteLine(query);
Console.ReadKey();
}
}

The output is:

Select * from tableName where id in ('abc', 'def', 'ghy', 'spd', 'xyz', 'uni');
Jignesh Trivedi12y ago
hi,

Same as insert you can use this as select also
like
In stored procedure I am using...
INSERT INTO CUSTOMER (CustomerId,CustomerName ,Isdeleted )
SELECT CustomerId, CustomerName, 0 AS Isdeleted FROM @TempTable

Instead of you can write like

Select * from Customer
where CustomerId in (select Customerid from @TempTable)

hope this will help you.
darma teja12y ago
Hi Jignesh,

Thanks for the reply.
I have gone through the articles, All those articles explains about inserting the data.

But I want to retrieve the data.

Darma
Jignesh Trivedi12y ago
hi,
In this case you can use table value parameter
Please refer my article
http://www.c-sharpcorner.com/UploadFile/ff2f08/table-valued-parameter-in-sql-server-2008/
http://www.c-sharpcorner.com/UploadFile/ff2f08/table-value-parameter-use-with-C-Sharp/

hope this will help you.