In clause db2 c#

string[] tags = new string[] { "ruby", "rails", "scruffy", "rubyonrails" };
const string cmdText = "select * from tags where '|' + @tags + '|' like '%|' + Name + '|%'";

using (SqlCommand cmd = new SqlCommand(cmdText)) {
   cmd.Parameters.AddWithValue("@tags", string.Join("|", tags);
}

Source: stackoverflow.com

Similar codes

8 votes89 views3 answers
Char to int c#
C#
0 vote165 views1 answer
Get sprite name from gameobject
C#
1 vote139 views1 answer
Convert array object to int[] c#
C#
4 votes126 views3 answers
Mysql list table columns
C#
0 vote124 views1 answer
Vector2 with switch statement
C#
0 vote133 views1 answer
Sum the digits in c#
C#
0 vote134 views1 answer
C# remove crlf from string
C#
5 votes148 views2 answers
C# get files of type in directory
C#
0 vote129 views1 answer
Largest prime factor of a number
C#
0 vote188 views1 answer
Moving camera with touch screen unity
C#Unity