Código C#:
Ver original
OleDbConnection BaseDatos = new OleDbConnection(); OleDbCommand Com = new OleDbCommand(); OleDbDataAdapter DA = new OleDbDataAdapter(); DataSet Ds = new DataSet(); DataTable table = new DataTable(); String consulta; //abrir base de datos BaseDatos.ConnectionString = @"PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=C:\doggy_park.mdb"; BaseDatos.Open(); //establecer conexion Com.Connection = BaseDatos; Com.CommandType = CommandType.Text; consulta = "select * from Cliente where id2 ;"; Com.CommandText = consulta; DA.SelectCommand = Com; DA.Fill(Ds, "doggy_park"); BaseDatos.Close(); try { // rellenar la tabla con los datos de la consulta DA.Fill(table); } catch (OleDbException ex) { // mostrar error MessageBox.Show(ex.Message); } catch (Exception ex) { // mostrar error MessageBox.Show(ex.Message); } listBox1.DisplayMember= "id2 "; listBox1.DataSource = table;