S
Samuel
Hello coders:
I'm trying to create a typed dataset from a Microsoft Access database. I
follow these steps (with visual studio 2003):
I add a new empty DataSet to the project (Project->Add New Item->Data Set).
I open the Server Explorer window and I create a new connection to my .mdb
database.
Then I drag the 'Tables' item under my connection to the dataset, and all
the tables are copied.
But thus the relations aren't copied, and the keys' names are incorrect, it
assigns new names to the keys like DataSet1KeyX, where X is a number.
I can't use DataAdapters to generate the typed dataset's schema because I
create DataAdapters manually by code, but also I don't know if using
DataAdapters would copy the relations and the keys correctly.
So, what's the way to generate a complete and correct dataset schema from an
existing database?
Thank you.
I'm trying to create a typed dataset from a Microsoft Access database. I
follow these steps (with visual studio 2003):
I add a new empty DataSet to the project (Project->Add New Item->Data Set).
I open the Server Explorer window and I create a new connection to my .mdb
database.
Then I drag the 'Tables' item under my connection to the dataset, and all
the tables are copied.
But thus the relations aren't copied, and the keys' names are incorrect, it
assigns new names to the keys like DataSet1KeyX, where X is a number.
I can't use DataAdapters to generate the typed dataset's schema because I
create DataAdapters manually by code, but also I don't know if using
DataAdapters would copy the relations and the keys correctly.
So, what's the way to generate a complete and correct dataset schema from an
existing database?
Thank you.