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

1 vote120 views1 answer
Moq raise event
C#
9 votes122 views4 answers
How to round in c#
C#
0 vote128 views3 answers
Bundle.config in mvc is missing
C#
3 votes147 views5 answers
Bitmap to byte array c#
C#
1 vote137 views1 answer
How to draw over label C#
C#
0 vote137 views1 answer
Linq query get last day of month
C#
0 vote136 views1 answer
What is a model in C#
C#
0 vote126 views1 answer
Asp.net file detect mime type
C#
0 vote127 views1 answer
How to minimum text length in textbox in c#
C#
1 vote124 views2 answers
Unity create random string
C#