Change DataSource at RunTime

4 May 2006 5:07 PM

Mario-LRJ

I Have some .mdb with the same table structure but different datas. So
i want to change at runtime the datasource without change de Form
design and the control binding... (if it's possible)

is that possible??

I thought to change only the connectionString and Refresh the DataSet,
but i don't think it's sufficient.

if that's correct, i really don't know how to change the
connectionString (autocreated at design time with a deafault
Datasource) and i don't know how to refresh all the datas
structures.... i'm sorry it's my first project.... and i'm alone

Anyone can help me! All suggestions and references are welcome.

5 May 2006 8:35 AM

Radenko Zec

If you now how to create Connection String and Control Binding rest is
simple.
Create another connection string and in runtime change connection strings.
Dataset1.refresh is easy as that.

Show quote

"Mario-LRJ" <larocca.ma***@gmail.com> wrote in message
news:1146762420.273645.111380@i40g2000cwc.googlegroups.com...
>I Have some .mdb with the same table structure but different datas. So
> i want to change at runtime the datasource without change de Form
> design and the control binding... (if it's possible)
>
> is that possible??
>
> I thought to change only the connectionString and Refresh the DataSet,
> but i don't think it's sufficient.
>
> if that's correct, i really don't know how to change the
> connectionString (autocreated at design time with a deafault
> Datasource) and i don't know how to refresh all the datas
> structures.... i'm sorry it's my first project.... and i'm alone
>
> Anyone can help me! All suggestions and references are welcome.
>