Copy Relationships from Access to a DataSet?

[Jman82]

My first question

I did a bit of searching and couldn't find an answer for this.

Is there a way to copy all the information about an Access DataBase to your dataSet, Including Relationships, Primary Keys, Index's, Tables and table Data?

I have already created my own function to pull out all the tables and table data from an Access DB to a DataSet using the connection.GetSchema("TABLES") meathod.

I was looking at the other schema tables to see an easy way to establish the relationships and keys but before i spent a buch of time deciphering the schema to create the relationships i wanted to check if I was missing something simple.

i noticed the dataSet.readXMLSchema / .writeXMLSchema would that be the correct direction. And how would i get the XMLSchema from an access DB?

I dont want to use the wizard to get the DataSet.

Thanks

 

[cjard]

is this crossposted?

 

[Jman82]

Sorry

Yea it is, I didnt realize i posted the first one in ADO.Net... Like it says I'm a newbie.

Sorry.