array in sql-where

Question

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

Vulpes · 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 Trivedi · Answer

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 teja · Answer

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 Trivedi · Answer

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.