MsAccess and comboboxes

[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.

 

[Cor Ligthert[MVP]]

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

 

[bpsdgnews]

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 -

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.

 

[Cor Ligthert[MVP]]

Bas,

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

That gives the content of a query mostly the best.

Cor