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

2 votes139 views1 answer
Ef Select 2 or more items from DB
C#
1 vote139 views1 answer
C# get set value
C#
7 votes162 views3 answers
How to change scenes on collision unity
C#Unity
1 vote121 views1 answer
Unity how to get the side ways velocity of a object
C#
0 vote123 views1 answer
Init stirng list c#
C#
0 vote123 views3 answers
How to fill model enum with bradio button asp razor
C#
1 vote135 views1 answer
Check valid binary search tree c#
C#
0 vote145 views1 answer
How to do division with button C#
C#
1 vote130 views1 answer
Access a local varible in a different function C#
C#
0 vote140 views1 answer
Rename join table ef core
C#