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 votes146 views1 answer
Asp.net data annotations email
C#
0 vote132 views1 answer
C# program that print charater from A to Z and it's corresponding number
C#
1 vote150 views1 answer
Best way to compare byte array c#
C#
0 vote128 views1 answer
C# xamarin forms use AssetManager to get text file
C#
1 vote140 views2 answers
C# datagridview column size
C#
10 votes138 views2 answers
List<string,string> c#
C#
0 vote145 views1 answer
How to chceck for a tag in a trigger enter 2d unity
C#
23 votes143 views3 answers
How to write hello world in c#
C#
1 vote134 views1 answer
How to show the value of a string in c#
C#
0 vote128 views1 answer
C# web scraping get images from specific url
C#