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

4 votes266 views4 answers
How to empty an array c#
C#
14 votes256 views3 answers
Print array in c#
C#
0 vote286 views1 answer
Skrivetænking
C#
2 votes263 views3 answers
Remove multiple items from list c#
C#
0 vote283 views1 answer
Cshtml page title
C#
7 votes281 views1 answer
How to convert int to string unity c#
C#Unity
0 vote292 views2 answers
C# for loop Statement
C#
3 votes292 views1 answer
How to make an object invisible unity
C#
7 votes243 views2 answers
Unity copy to clipboard
C#Unity
5 votes286 views3 answers
Unity audiosource play
C#Unity