C#

Bardy85 wrote:

Are you trying to do this is SQL, or in code?

Dictionary<char, List<int>> list = new Dictionary<char, List<int>>();

foreach(char c in list.Keys)
   list[c].Add(...); // issue a second query here

static void Main(string[] args)
{
    List<string> match = new List<string> { "a", "b", "apple", "c", "grape" };
    List<string> fruits = new List<string> { "apple", "passionfruit", "banana", "mango", "orange", "blueberry", "grape", "strawberry" };

    var query1 = from matchList in match
                 select matchList;


    var query2 = from myFruits in fruits
                join matchList in query1 on myFruits equals matchList
                select myFruits;

    foreach (var item in query2)
    {
        Console.WriteLine(item);
    }
    Console.Read();
}</string></string></string></string>

System.Collections.Generic.HashSet<string> match =
    new System.Collections.Generic.HashSet<string>
    { "a", "b", "apple", "c", "grape" } ;
 
System.Collections.Generic.HashSet<string> fruits =
    new System.Collections.Generic.HashSet<string>
    { "apple", "passionfruit", "banana", "mango", "orange", "blueberry", "grape", "strawberry" } ;
 
System.Collections.Generic.HashSet<string> intersection =
    new System.Collections.Generic.HashSet<string>
    (
        match
    ) ;
 
intersection.IntersectWith ( fruits ) ;

private void MyDataGridViewInitializationMethod()
{
    ...
    dataGridView.EditingControlShowing +=
new DataGridViewEditingControlShowingEventHandler(dataGridView_EditingControlShowing);
}

private void dataGridView_EditingControlShowing(object sender, DataGridViewEditingControlShowingEventArgs e)
{
    e.Control.KeyPress +=
        new KeyPressEventHandler(Control_KeyPress);
}

private void Control_KeyPress(object sender, KeyPressEventArgs e)
{
    if (char.IsNumber(e.KeyChar))
    {
       //your code here
    }
}