Two String in Where Condition for one Column.

prince raj

12y1.6kLearn iOS Programming

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.

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes12y ago
Accepted 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', 'Strong Orange', 'none', 'Faint Red', 'Faint White', 'Faint Orange')
prince raj12y ago
ok, this is different between 1 year and 13 year experience.

what can i do for Become master in .net like you ?.
Vulpes12y ago
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 raj12y ago
Thanks Vulpes,

Can i ask One Question ?

How you got huge knowledge in programming ?
Vulpes12y ago
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 Singh12y ago
Hi prince,

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