Link sdf database to access database so tables can be updated in a dataset VB.net
Is there a way to link .sdf databases to an access database. I want to be able to update tables in in one from another?
I have both tables showing in a single typed data set. But how do i link the 2 so I can run sql satements on both. Hope this makes sence.
I have both tables showing in a single typed data set. But how do i link the 2 so I can run sql satements on both. Hope this makes sence.
ASKER
Hi Cyberkiwi,
Thanks I was hoping there was a way of joining them in the same dataset.
So if I should have 2 different datasets say one Access_dataset and one SDF_Local_dataset and each of these has a table called customers with the same datatypes and colomns. How do I write an sql join for them?
Thanks I was hoping there was a way of joining them in the same dataset.
So if I should have 2 different datasets say one Access_dataset and one SDF_Local_dataset and each of these has a table called customers with the same datatypes and colomns. How do I write an sql join for them?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Ok I like that Idea, so if i fill a datatable in one dataset, how do i put that into another?
They both will have the same schema.
They both will have the same schema.
ASKER
I think I know how to do this now.
If you mean to have a sql statement run against both at the same time, then no.
You will need to code the sql joins in VB.Net by processing 2 separate DataSets, one from each of SQL CE and Access.