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

0 vote171 views1 answer
Asp.net mvc 5 codefirst dropdown list
C#
0 vote242 views1 answer
Unity PlayOneShoot Audio
C#Unity
0 vote176 views1 answer
Is and as in c#
C#
0 vote187 views1 answer
How to get properties from json in c#
C#
0 vote172 views2 answers
How to find current country c#
C#
0 vote242 views1 answer
Asp net c# browser cursor wait
C#
4 votes184 views1 answer
Parsing string to int c#
C#
0 vote242 views2 answers
FiveM pc key code
C#
5 votes137 views3 answers
Unity 2d rotation
C#
0 vote178 views1 answer
C# get every point in a line in matrix
C#