Dataset Question

[Martin Horn]

Hi,

I have used the datasource wizard to add a local datasource to a combo box.
This all works fine up to a point, but what I want to do is at runtime,
specify the path to the database file that the combo box should be bound to
as it may not always be in the same location.

The Wizard has added a DataSet, a DataConnector and a TableAdaptor and the
database.mdb and a DataSet.xsd have been added in solution explorer.
I'm using Visual Basic 2005 Express Beta.
If this is posted in the wrong group, I apologise and would appreciate it if
someone could point me in the right direction.

Thanks in advance,

Martin Horn.

[W.G. Ryan eMVP]

All the designer is doing is writing code for you. All you need to do is
store those values somewhere, for instance in a config file, and then set
the properties whenever your form loads.

--
W.G. Ryan, MVP

www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
"Martin Horn" <ma****@mhorn.co.uk> wrote in message
news:DF****************@newsfe1-gui.ntli.net...

Hi,

I have used the datasource wizard to add a local datasource to a combo box. This all works fine up to a point, but what I want to do is at runtime,
specify the path to the database file that the combo box should be bound to as it may not always be in the same location.

The Wizard has added a DataSet, a DataConnector and a TableAdaptor and the
database.mdb and a DataSet.xsd have been added in solution explorer.
I'm using Visual Basic 2005 Express Beta.
If this is posted in the wrong group, I apologise and would appreciate it if someone could point me in the right direction.

Thanks in advance,

Martin Horn.

[W.G. Ryan eMVP]

All the designer is doing is writing code for you. All you need to do is
store those values somewhere, for instance in a config file, and then set
the properties whenever your form loads.

--
W.G. Ryan, MVP

www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
"Martin Horn" <ma****@mhorn.co.uk> wrote in message
news:DF****************@newsfe1-gui.ntli.net...

Hi,

I have used the datasource wizard to add a local datasource to a combo box. This all works fine up to a point, but what I want to do is at runtime,
specify the path to the database file that the combo box should be bound to as it may not always be in the same location.

The Wizard has added a DataSet, a DataConnector and a TableAdaptor and the
database.mdb and a DataSet.xsd have been added in solution explorer.
I'm using Visual Basic 2005 Express Beta.
If this is posted in the wrong group, I apologise and would appreciate it if someone could point me in the right direction.

Thanks in advance,

Martin Horn.

[Cor Ligthert]

Martin,

I would not say wrong group, however we mostly don't answer 2005 questions
here, there are more proper discussion groups, with posting too that has
Microsoft directly more change to see the Beta problem in my opinion.

http://communities.microsoft.com/new...idbey&slcid=us

I hope this helps?

Cor

[Cor Ligthert]

Martin,

I would not say wrong group, however we mostly don't answer 2005 questions
here, there are more proper discussion groups, with posting too that has
Microsoft directly more change to see the Beta problem in my opinion.

http://communities.microsoft.com/new...idbey&slcid=us

I hope this helps?

Cor