I had a situation where I need to use a string array in sql where-in clause
Code:strQuery = String.Format(strQuery, String.Join(",", stringArray)
I also need to convert an integer array to the string array. I did the conversion by iterating through the array.
If you don't want to do this way, there are other ways available from .net and linq:
1.
a)
Code:
//...
string[] stringArray =
Array.ConvertAll<int,string>
(intArray,new Converter<int,string>
(ConvertIntToString));
//...
private string ConvertIntToString(int intParameter)
{
return intParameter.ToString();
}
b) a compact form
Code:string[] stringArray = Array.ConvertAll<int,string>(ids, delegate(int intParameter) {return intParameter.ToString();});
2. linq
a)
Code:Array.ConvertAll<int, string>(INTARRAY, intParameter => intParamter.ToString());
b)
Code:var STRINGARRAY = INTARRAY.Select(s => s.ToString());
c)
Code:string[] stringArray = intArray.Select(i => i.ToString()).ToArray();