Draw database diagram using Silverlight
-
Hi I am having the requirement like drawing the database relationship diagram. Please find the sample image in the below path. http://siebelunleashed.com/wp-content/uploads/2008/06/informaticasourcequalifierscreenshot.png 1. By default, each table icon is in the minimized state & is displayed as a clickable button. 2. If the user click on it, it will be maximized & all the columns displayed (with scroll, if number of columns exceeds its maximum limit) 3. The user can move the icons anywhere around the UI boundaries. 4. The user can minimize it back to an icon by clicking on the minimize botton. 5. There is a connector between related tables (primary/ foreign key relationship) Column wise connector is not required in my case. Only one connector between the related tables is required. 6. If the user clicks on the connector, the relationship details will be displayed in a popup window. How can we implement the same in Web UI using Silverlight? Till now, I have tried with WCF for the database connectivity & drawn few movable images (Image control with mouse event handlers) and connectors (line control) between them by created all the controls dynamically from code behind file (xaml.vb) Kindly help us with your valuable suggestions on this. :) Thanks Jeyakumar
Jey
-
Hi I am having the requirement like drawing the database relationship diagram. Please find the sample image in the below path. http://siebelunleashed.com/wp-content/uploads/2008/06/informaticasourcequalifierscreenshot.png 1. By default, each table icon is in the minimized state & is displayed as a clickable button. 2. If the user click on it, it will be maximized & all the columns displayed (with scroll, if number of columns exceeds its maximum limit) 3. The user can move the icons anywhere around the UI boundaries. 4. The user can minimize it back to an icon by clicking on the minimize botton. 5. There is a connector between related tables (primary/ foreign key relationship) Column wise connector is not required in my case. Only one connector between the related tables is required. 6. If the user clicks on the connector, the relationship details will be displayed in a popup window. How can we implement the same in Web UI using Silverlight? Till now, I have tried with WCF for the database connectivity & drawn few movable images (Image control with mouse event handlers) and connectors (line control) between them by created all the controls dynamically from code behind file (xaml.vb) Kindly help us with your valuable suggestions on this. :) Thanks Jeyakumar
Jey
You should be able to do it similar to the way you'd do it in WPF, except you won't have direct access to a database from a browser so you'll need that info from a server. The Silverlight SDK[^] has lots of info on using Silverlight controls and graphics.
Mark Salsbery Microsoft MVP - Visual C++ :java:
