MsAccess and comboboxes

  • Thread starter Thread starter bpsdgnews
  • Start date Start date
B

bpsdgnews

Hi,


I'm using vb.net 2008. I can't figure out how I can set an MsAccess
query to the datasource property of a combobox.
 
Can you explain this a little bit in another way, do you mean to get a
datatable as a datasource or a find a datasource?

Cor
 
Can you explain this a little bit in another way, do you mean to get a
datatable as a datasource or a find a datasource?

Cor







- Tekst uit oorspronkelijk bericht weergeven -
Click to expand...

Well, in Access the're all called queries right? In vb.net some show
up as view (select queries) and some show up as stored procedure (e.g.
union queries).

If I create a datasource from a table, I can use that to put in the
datasource property of a combobox. Then add the column of choice in
the displaymember property of the combobox and everything is fine.

When I try to do that with a query that showed up as a stored
procedure, I don't get a column to put in the displaymember property.
When I try to do that with a query that shows up as a view, I can do
everything the same way as with a table, but the list of the combobox
just doesn't get filled.

Bas.
 
Bas,

Then try first a datagridview before you start with your combobox.

That gives the content of a query mostly the best.

Cor
 
Back
Top