Flylib.com
List of Figures
Previous page
Table of content
Next page
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
Previous page
Table of content
Next page
ADO.NET Programming with CDR (Wordware programming library)
ISBN: 1556229658
EAN: 2147483647
Year: 2005
Pages: 28
Authors:
Terrence Joubert
BUY ON AMAZON
ERP and Data Warehousing in Organizations: Issues and Challenges
ERP Systems Impact on Organizations
Enterprise Application Integration: New Solutions for a Solved Problem or a Challenging Research Field?
Context Management of ERP Processes in Virtual Communities
Distributed Data Warehouse for Geo-spatial Services
Data Mining for Business Process Reengineering
The CISSP and CAP Prep Guide: Platinum Edition
Telecommunications and Network Security
The Accreditation Phase
Appendix A Answers to Assessment Questions
Appendix F Security Control Catalog
Appendix G Control Baselines
A Practitioners Guide to Software Test Design
Section I - Black Box Testing Techniques
Pairwise Testing
Section III - Testing Paradigms
Scripted Testing
Appendix B Stateless University Registration System Case Study
Systematic Software Testing (Artech House Computer Library)
Master Test Planning
Improving the Testing Process
Some Final Thoughts…
Appendix D Sample Master Test Plan
Appendix E Simplified Unit Test Plan
C & Data Structures (Charles River Media Computer Engineering)
Data Types
The scanf Function
Recursion
Arrays, Searching, and Sorting
Trees
PostgreSQL(c) The comprehensive guide to building, programming, and administering PostgreSQL databases
Transaction Processing
Extending PostgreSQL
Defining the Data Type in PostgreSQL
Client 1Connecting to the Server
The PostgreSQL BGWRITER process
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies