Question display dynamic Database relational schema

[Ramyzo]

im working on making an automatic OLAP cube with C# i need little help how to display an relational database schema (the database is taking from the SQL server )

 

[jmcilhinney]

I'm not sure what you mean by

display an relational database schema

Are you talking about something like the diagrams you can create in SSMS?

 

[Ramyzo]

Something like that sir !

Well my application will allow the user to choose a database and a number of tables within it ! and after i want to display a diagram for him with the chosen tables ! is it possible sir ?

 

[jmcilhinney]

There's nothing built into Windows Forms to do that automatically. You could relatively easily design a user control to represent a table though, adding the appropriate controls based on the number of columns in the table and then adding as many as you need to your form. You could then connect them with lines drawn using GDI+. A TableLayoutPanel in the user control would probably be a good idea. I suggest that you give it some thought, do some research and experiment a bit, then post back when you encounter a specific issue.

 

[Ramyzo]

Thanks Sir ^^ i will do some reasearch and see what i can do !