Is there a way to retrieve all of the tables and there relationships into a dataset using code? I have only seen some of this done using the erver explorer. I am trying to create a simple application that will backup a database. The user will navigate to the database and then be able to back it up. I was thinking of using a strongly typed dataset to accomplish this. So does anyone know how to get the database tables with relationships from a database into a dataset without using the server explorer or having to know the relationships ahead of time and recreate them programattically using code?
Thanks, Chester
Thanks, Chester