Two String in Where Condition for one Column.

Question

I have One Column in Database

Fluorescences |

---------------------

Medium Blue

Strong blue

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.