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
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