Retrieving the Tables Relationship from SQL Server Database Diagrams

  • Thread starter Thread starter hadi
  • Start date Start date
H

hadi

Hi All,

Currently i am defining a simple relationship between
Customers->Orders->Order Details through the Database Diagrams feature in
the SQL 2K. Using the Server Explorer, i can see the Database Diagrams, but
when i try to "drop" the Database Diagrams into the page, it gives the error
message.

I would like to know the procedures to retrieve the database relationships
from Database Diagrams and manipulate them through ADO.NET

Thank you very much for all your help

Regards.

hadi
 
hi hadi
what does this error message say ? You might achieve this
functionality be creating a typed dataset and define all these relations in
the visual designer so it would be mapped in the xsd file that has the
schema of your typed dataset
Mohamed Mahfouz
MEA Developer Support Center
ITworx on behalf of Microsoft EMEA GTSC
 
Hi All,

I prefer to "convert" already defined relationship using SQL Server Database
Diagrams into XSD file or probably you have another method to "read" those
relationship and manipulate them.

Regards,

hadi
 
Back
Top