array in sql-where

Question

Hi I have a string array. Example: string[] test =new string[3] {abcdef ghyspd xyzuni}; 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] {abcdef ghyspd xyzuni}; 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 (CustomerIdCustomerName 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.