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

2 votes103 views1 answer
C# write byte[] to stream
C#
1 vote101 views1 answer
Remove index from array c#
C#
0 vote103 views1 answer
Move files from one folder to another using c#
C#
4 votes100 views1 answer
How to see if they are aholding down a key unity
C#Unity
0 vote102 views1 answer
Il c#
C#
1 vote110 views1 answer
C# how to output in between 0 - 100 in an int array
C#
2 votes145 views1 answer
Unity c# set object tag
C#Unity
0 vote93 views1 answer
How to go to other forms in C#
C#
0 vote97 views1 answer
Hello world in unity c#
C#
1 vote140 views1 answer
Unity organize variables in inspector
C#Unity