private void searsh_Click(object sender, EventArgs e)
{
OleDbConnection con1 = new OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=.\\data.mdb");
OleDbDataAdapter ad1 = new OleDbDataAdapter("select patient.fname AS المريض, patient.lname AS المرض, patient.gender AS الجنس, tblmid.name AS الدواء FROM tblmid INNER JOIN (patient INNER JOIN select_m ON patient.id = select_m.idd) ON tblmid.id = select_m.id where patient.fname='" + textbox1.Text + "'", con1);
DataSet ds = new DataSet();
ad1.Fill(ds, "results");
// ds.Tables[0].Columns[1].DefaultValue = "Mr";
dataGridView1.DataSource = ds;
dataGridView1.DataMember = "results";
dataGridView1.Columns.Remove("الدواء");
DataGridViewComboBoxColumn comboboxColumn = new DataGridViewComboBoxColumn();
comboboxColumn.DataPropertyName = "الدواء";
comboboxColumn.HeaderText = "دوا";
comboboxColumn.DropDownWidth = 50;
comboboxColumn.Width = 50;
comboboxColumn.MaxDropDownItems = 5;
comboboxColumn.FlatStyle = FlatStyle.Flat;
OleDbCommand dbComboCommand = new OleDbCommand();
dbComboCommand.Connection = con1;
dbComboCommand.CommandText = "select tblmid.name AS دواء FROM tblmid INNER JOIN (patient INNER JOIN select_m ON patient.id = select_m.idd) ON tblmid.id = select_m.id where patient.fname='bassel alshiblack'";
OleDbDataAdapter dbComboDA = null;
dbComboDA = new OleDbDataAdapter(dbComboCommand);
DataSet Cds = new DataSet();
dbComboDA.Fill(Cds, "results");
comboboxColumn.DataSource = Cds.Tables[0];
comboboxColumn.ValueMember = "دواء";
comboboxColumn.DisplayMember = comboboxColumn.ValueMember;
dataGridView1.Columns.Insert(1, comboboxColumn);
}ثلاث جداول patient و select_m و tblmid وعندما اضغط زر بحث تظهر المعلومات على الجريد فيو ولكن الكومبو لا يعمل اي تضهر المعلومات (عدة اسطرحسب عدد الادوية مع تكرار الاسم والمرض ....) بدلا من سطر واحد يوجد فيه الاسم والمرض و ... وكمبو بكس فيه الادوية للمريض