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 vote281 views1 answer
C# ping all machines on local network
C#
1 vote247 views1 answer
Check if current time is in the morning c#
C#
14 votes275 views1 answer
Unity string split
C#Unity
0 vote252 views1 answer
Xamarin forms uwp button hover
C#
1 vote260 views1 answer
C# string contains any of list
C#
1 vote232 views1 answer
How to search for a string from readline in c#
C#
14 votes234 views1 answer
C# length 2d array
C#
0 vote245 views1 answer
Replaced OS is obselete
C#
0 vote232 views1 answer
How to make diagonal movement not double the speed of the player in unity
C#
1 vote242 views1 answer
Mvc select list order by
C#