try it with Dataset
Dataset ds = new Dataset();
DataAdapter dt = new dataAdapter(Com);
dt.fill(ds);
comboBox2.DataSource = ds;
comboBox2.DisplayMember = "MemberName";
comboBox2.ValueMember = "MemID";
try
{
connection.Open();
OleDbDataReader dr = command.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
comboBox1.Items.Add(dr["CountryName"]);
}
}
}
catch (Exception ex)
{
MessageBox.Show("The following error occured :rn" + ex.ToString());
}
finally
{
connection.Close();
dr.Close();
}
}