Dynamic search and display options in combo boxes

See more:

C#

Visual-Studio

LINQ

combobox

, +

Original title: "Dynamic search and display options in the search drop down list in the table that the search was conducted at the same time"

Hi
I have a combobox in the table.
I want to change the text inside the combobox inside the Grid ,columns in several tables to do my search and found items to display
For example, such code

private void Grid1_EditingControlShowing(object sender, DataGridViewEditingControlShowingEventArgs e)
{
    if (Grid1.CurrentCell.ColumnIndex==2)
    {
        e.Control.TextChanged += Grid1_TextChanged;
    }

}

private void Grid1_TextChanged(object sender, EventArgs e)
{
    var list = from p in db.Drugs
               where p.VirtualCode.Contains(Grid1.CurrentRow.Cells["dName"].Value.ToString())
               join
               q in db.GenericDrugs
               on p.GenericID equals q.GenericID
               select q;
    dName.DataSource = list;
    dName.DisplayMember = "Genericname";

}

My first problem is that
At the same time these items in the dropdown list does not display
What should I do to open the dropdown list at the same time the display?