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 vote180 views2 answers
C# how to get a securestring from string
C#
2 votes257 views1 answer
Unity load current scene
C#Unity
0 vote175 views1 answer
Csharp datagridview filter column
C#
1 vote163 views1 answer
How to convert a Decimal to a Double in C#?
C#
3 votes235 views1 answer
Unity get speed of object
C#Unity
6 votes252 views3 answers
Favicon png
C#
0 vote163 views2 answers
Get after point in c#
C#
13 votes173 views2 answers
How to make a multiplayer game in unity
C#Unity
1 vote169 views1 answer
Unity time.deltatime timescale 0
C#
0 vote180 views1 answer
Non null array length
C#