List of Figures

Chapter 2: Interacting with Databases

Figure 2-1: A view inside a .NET data provider

Chapter 3: Data Manipulation

Figure 3-1: The organization of the DataSet component

Chapter 4: Designing ADO .NET Applications

Figure 4-1: Windows Forms data binding architecture
Figure 4-2: XML Web Service communication cycle

Chapter 5: XML Integration with ADO .NET

Figure 5-1: The DOM tree
Figure 5-2: Relation between the Categories and Products tables

Chapter 6: Practical ADO .NET Programming (Part One)

Figure 6-1: Creating a virtual directory in IIS between Categories and Products
Figure 6-2: Creating the OrderProcessingWS project
Figure 6-3: The skeleton of the class and namespace
Figure 6-4: Web page generated by IIS for the OrderProcessingWS Web Service
Figure 6-5: Test page for GetOrders_By_Customer
Figure 6-6: Tables, columns, and relationships for GetFullOrders methods
Figure 6-7: Design view of OrdersDs.xsd

Chapter 8: Migrating ADO Applications

Figure 8-1: The Add Reference dialog
Figure 8-2: ADODB namespace added to the project

Chapter 9: Manipulating Multidimensional Data

Figure 9-1: The Install Components dialog for the SQL Server 2000 Developer Edition
Figure 9-2: The Select Components dialog
Figure 9-3: The Select Program Folder dialog
Figure 9-4: Analysis Services architecture
Figure 9-5: The relational structure of the FoodMart database
Figure 9-6: The ADO MD object model
Figure 9-7: The Visual Studio .NET Designer
Figure 9-8: A view of the OLAP database containing the output of the Form1 object
Figure 9-9: Selecting the OLAPCubeBrowser.CubeBrowser control
Figure 9-10: Adding a library to the Selected Components list box

Appendix A: The Object-Oriented Features of VB .NET

Figure A-1: The Visual Studio .NET development environment
Figure A-2: The frmExample form
Figure A-3: The Add New Item dialog
Figure A-4: The Solution Explorer showing the Customer.vb class
Figure A–5: The relationship between member variables and properties
Figure A-6: The result of the sample application
Figure A-7: A chain of inheritance

Appendix B: Database Normalization

Figure B-1: Customer orders data
Figure B-2: Removal of repetitive groups
Figure B-3: Splitting the table into two separate tables
Figure B-4: Relating the Order and OrderDetail tables
Figure B-5: The OrderDetail and Product tables, which are in 2NF
Figure B-6: The new Account group

Appendix C: Views, Stored Procedures, and Triggers

Figure C-1: The New View window
Figure C-2: The Design View window showing the “Alphabetical list of products” view
Figure C-3: Diagram pane for Order Header Query view
Figure C-4: Error generated by trigger

Appendix D: Advanced SQL Query Techniques

Figure D-1: Orders, Order Details, and Products tables
Figure D-2: The columns of the Employees table
Figure D-3: Sample result set for sale value of products using GROUP BY
Figure D-4: Extra row produced by GROUP BY with ROLLUP
Figure D-5: Additional rows generated by ROLLUP
Figure D-6: Some of the additional rows generated by CUBE
Figure D-7: The return result from the view [CUBE EmployeeProduct]
Figure D-8: Result of counting employees for each Title and Country
Figure D-9: Simple cross-tab for employees
Figure D-10: Sample result of running sp_Product_Employee_xtab