Introducing ASP.NET 2.0 with Visual Studio 2005 - Creating Data Diagrams and Views using the Visual Studio 2005 “Server Explorer” Window

(Page 4 of 4 )

Data Diagram:

• Select the Data Diagram object, right click on it and click on “Add New Diagram” option
  
• Select each and every table, whatever is required and click the “Add” button. Added tables will be displayed on the design pane. From the design pane we can establish relationships by dragging and dropping a child column onto the parent column (between the two tables) very easily. We can even add new tables to the diagram using the “New Table” icon on the toolbar. Try to create a relationship like the one shown in the following Figure 7.

• After creating a database diagram, save it as Diagram1.

Views:

• Add a new View similar to the above diagram object. Select required tables, views, functions or synonyms and add to the design pane.
  
• You will be able to observe that the window is divided into four panes.
  • Diagram Pane: represents all objects (and their relations) in the form of diagrams.
  • Criteria Pane: can provide conditions within this pane.
  • SQL Pane: can directly specify (or modify) the SELECT statement, which is used to create the view.
  • Result Pane: displays sample output of created view.

In Figure 8, I created a view and executed it to display employee details along with their department names and the location of departments.  Try to design it experimentally.

 

Any comments, suggestions, bugs, errors, feedback etc. are highly appreciated at jag_chat@yahoo.com.

DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware.

Comments On: Introducing ASP.NET 2.0 with Visual Studio 2005

· Hello guys, you can find the basics of ASP.NET 2.0 with Visual Studio 2005 here. Do...    · Thanks! Your article is clear and easy to grasp! Write more :)Yobo!    · Hi,thanks for your compliments. I am already on the way to contribute huge number...    · Hi thks for such a gud article...    · This is a really good article and authours tried to make undertsand the differences...   >>> Post your comment now!