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

52 votes364 views6 answers
How to print something in c#
C#
0 vote321 views1 answer
Usermanager find based on role
C#
1 vote336 views1 answer
What is the meaning of ?? in c#
C#
0 vote304 views1 answer
C# wpf get clipboard text
C#
0 vote316 views1 answer
How to convert pdfdocument to binary in c#
C#
-1 vote301 views2 answers
C# extend array
C#
0 vote311 views1 answer
Telerik raddatepicker default date today wpf
C#
2 votes300 views7 answers
Covid
C#
0 vote312 views1 answer
Ascx access parent master page
C#
0 vote362 views1 answer
Fetch error Not Found /swagger/v1/swagger
C#