Two String in Where Condition for one Column.

Question

I have One Column in Database Fluorescences | --------------------- Medium Blue Strong blue Strong blue none none strong Red none medium White Faint White strong Yellow VeryStrong Orange Strong Red Faint Blue ---------------------------------- Now i have two string string s1 = "Strong, none, Faint"; string s2 = "Red, White, Orange"; now i want to write Where Condition for Fluorescences Column in select Query How can i ? i want to use both string in where for one column.

Vulpes · Answer

Ah, the penny has finally dropped as to what you want here. Try this instead: using System; using System.Collections.Generic; using System.Text.RegularExpressions; class Program { static void Main() { string s1 = "Strong, none, Faint"; string s2 = "Red, White, Orange"; string query = "SELECT * FROM table WHERE Fluorescences "; query += GenerateInClause(s1, s2); Console.WriteLine(query); Console.ReadKey(); } static string GenerateInClause(string s1, string s2) { var list = new List (); string[] items1 = Regex.Split(s1, @",\s*"); string[] items2 = Regex.Split(s2, @",\s*"); foreach(string item1 in items1) { foreach(string item2 in items2) { if (item1 == "none" || item2 == "none") { if(!list.Contains("none")) { list.Add("none"); } } else { list.Add(item1 + " " + item2); } } } string s = Regex.Replace(String.Join(", ", list.ToArray()), @"\w+( \w+)?", @"'$0'"); return "IN (" + s + ")"; } } The output now is: SELECT * FROM table WHERE Fluorescences IN ('Strong Red', 'Strong White', 'Stron g Orange', 'none', 'Faint Red', 'Faint White', 'Faint Orange')

prince raj · Answer

ok, this is different between 1 year and 13 year experience. what can i do for Become master in .net like you ?.

Vulpes · Answer

I've been using .NET since the version 1.0 beta about 13 years ago so I've accumulated a lot of knowledge about it during that time.

prince raj · Answer

Thanks Vulpes , Can i ask One Question ? How you got huge knowledge in programming ?

Vulpes · Answer

The following will generate an IN clause for each of those strings: using System; using System.Text.RegularExpressions; class Program { static void Main() { string s1 = "Strong, none, Faint"; string s2 = "Red, White, Orange"; string query = "SELECT * FROM table WHERE Fluorescences "; string query1 = query + GenerateInClause(s1); string query2 = query + GenerateInClause(s2); Console.WriteLine(query1); Console.WriteLine(query2); Console.ReadKey(); } static string GenerateInClause(string s) { s = Regex.Replace(s, @"\w+", @"'$0'"); return "IN (" + s + ")"; } } The output is: SELECT * FROM table WHERE Fluorescences IN ('Strong', 'none', 'Faint') SELECT * FROM table WHERE Fluorescences IN ('Red', 'White', 'Orange')

Anupam Singh · Answer

Hi prince, Your question is not clear .Can you specify what output you want for the same.