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 vote330 views1 answer
Reference a class by string unity
C#Unity
3 votes305 views1 answer
C# loop array backwards
C#
1 vote293 views1 answer
C# winforms tooltip
C#
0 vote343 views1 answer
Unity exenerate
C#Unity
0 vote299 views1 answer
What is the best way to lock cache in asp.net?
C#
2 votes305 views1 answer
Parse excel file to class object c#
C#
2 votes330 views1 answer
Serilog log level hierarchy
C#
0 vote308 views1 answer
C# loop class properties add to array
C#
0 vote310 views2 answers
_swapbatch.foreach multiple statements c#
C#
1 vote296 views1 answer
Xamarin overlay
C#