private void combobox_name_SelectedIndexChanged(object sender, EventArgs e)
{
OdbcConnection con = new OdbcConnection(ConnectionString);
con.Open();
combobox_contact.Items.Clear();
combobox_address.Items.Clear();
combobox_function.Items.Clear();
string SQLQuery = "Select contact, address,function from Information where name='"+combobox_name.Text+"' ";
OdbcDataAdapter da1 = new OdbcDataAdapter(SQLQuery, con);
da1.Fill(ds);
combobox_contact.DataSource = ds.Tables[0];
combobox_contact.DisplayMember = "Contact";
combobox_address.DataSource = ds.Tables[0];
combobox_address.DisplayMember = "address";
combobox_function.DataSource = ds.Tables[0];
combobox_function.DisplayMember = "function";
combobox_contact.ValueMember = "Contact";
}
I hope this will help you ,REPLY ME............