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 vote208 views1 answer
Prevent page refresh
C#
0 vote221 views1 answer
Startup c# class winform
C#
0 vote207 views1 answer
Linq cross join
C#
7 votes220 views2 answers
How to convert int to float in c#
C#
0 vote209 views2 answers
How to read reportview query string asp.net c#
C#
0 vote234 views1 answer
Unity deactivate scripts in list
C#Unity
1 vote195 views2 answers
Should i learn c #
C#
1 vote205 views1 answer
Moq raise event
C#
0 vote215 views1 answer
Get min date in list c#
C#
0 vote213 views2 answers
How can i replace Any for All method and vice versa linq in c#
C#