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 vote112 views1 answer
C# read all lines from filestream
C#
3 votes119 views1 answer
C# @ before string
C#
0 vote112 views2 answers
C# how to convert string to float
C#
19 votes107 views6 answers
Bootstrap popup
C#
0 vote144 views1 answer
Unity animation length
C#Unity
0 vote118 views1 answer
SQLite Parameters
C#
3 votes115 views1 answer
Unity how to change the text on a button
C#
0 vote111 views1 answer
Monegame deltatime
C#
0 vote129 views1 answer
How to call method in different project in c# visual studio
C#
7 votes120 views4 answers
C# list index
C#