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 vote190 views1 answer
Windows 10 see how long a program has been running
C#
0 vote183 views1 answer
Is keyboard clicked in Unity
C#Unity
6 votes180 views6 answers
C# application exit
C#
4 votes187 views1 answer
Unity new vector3
C#
-1 vote186 views2 answers
Error CS1513: } expected but there is already unity
C#
8 votes136 views1 answer
Unity raycast 2d
C#Unity
-1 vote140 views1 answer
C# resize image from byte array
C#
5 votes152 views2 answers
Unity or
C#
3 votes168 views1 answer
Type is not marked as serializable.
C#
1 vote168 views1 answer
Asp.net validate web.config
C#