Flylib.com

Books Software

 
 
 

Part IV: Appendices

Part IV: Appendices

Appendix A: The Object Oriented Features of VB.NET
Appendix B: Database Normalization
Appendix C: Views, Stored Procedures, and Triggers
Appendix D: Advanced SQL Query Techniques

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

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

In This Appendix

This appendix provides an overview of object-oriented programming and covers the features in VB .NET that allow developers to write object-oriented applications for the .NET Framework.

Topics discussed are:

  • Overview of OOP support in Visual Basic in the past

  • Object-oriented programming concepts

    • Classes and objects

    • Members, properties, and methods

    • Inheritance and polymorphism

  • Development of a small object-oriented application

Appendix B: Database Normalization

Appendix B: Database Normalization

In This Appendix

This appendix provides a definition of normalization and explains the process of normalization.

Appendix C: Views, Stored Procedures, and Triggers

Appendix C: Views, Stored Procedures, and Triggers

In This Appendix

This appendix provides a discussion of views, stored procedures, and triggers, and the steps involved in their implementation inside SQL Server 2000. The main tools used in this chapter are the Query Analyzer and the Enterprise Manager.

Topics discussed are:

  • The concepts of views, stored procedures, and triggers

  • The usage of views, stored procedures, and triggers

  • The implementation of views, stored procedures, and triggers using the Query Analyzer

Appendix D: Advanced SQL Query Techniques

Appendix D: Advanced SQL Query Techniques

In This Appendix

This appendix will show you various tricks and techniques that you can use with SQL queries.

These include:

  • Advanced insertion and deletion

  • Recursive stored procedures

  • Dynamic queries

  • Stored procedure generator

  • GROUP BY with CUBE and ROLLUP

  • Server cross tabulations with SQL

    Note 

    In this appendix, all examples will use the Northwind database, as is the case throughout the book. Some of the examples in this appendix will cause deletion of data. It is, therefore, recommended that you back up the Northwind database so that you can restore it after you are done with this appendix.

Index

A

AcceptChanges() method, 76

AcceptChangesDuringFill property, 57

ActiveX Data Object Multidimensional, see ADO MD

ADO,

architecture, 4-7

data types, 6-7

using JOIN in, 12-13

using with ADO .NET, 250-251

ADO MD, 274-275

ADO .NET,

architecture, 7-9

integration with XML, 133-134

using with ADO, 250-251

Analysis Services, 262

architecture of, 270-271

installing, 262-265

setting up, 266-270

application, protecting, 129-130

application scope, 122

architecture,

ADO, 4-7

ADO .NET, 7-9

differences between ADO and ADO .NET, 3

ASP, using with ASP .NET, 250

ASP .NET applications, 106

data access in, 115-119

using with ASP, 250

attributes, 136

About the CD

CD Content

The CD-ROM included with this book contains examples that demonstrate ADO .NET topics discussed in the book. The examples are organized by chapter in the Code Samples folder.

Warning 

By opening the CD package, you accept the terms and conditions of the CD/Source Code Usage License Agreement on the following page.

Opening the CD package makes this book nonreturnable.

CD/Source Code Usage License Agreement

Please read the following CD/Source Code usage license agreement before opening the CD and using the contents therein:

  1. By opening the accompanying software package, you are indicating that you have read and agree to be bound by all terms and conditions of this CD/Source Code usage license agreement.

  2. The compilation of code and utilities contained on the CD and in the book are copyrighted and protected by both U.S. copyright law and international copyright treaties , and is owned by Wordware Publishing, Inc. Individual source code, example programs, help files, freeware, shareware, utilities, and evaluation packages, including their copyrights, are owned by the respective authors.

  3. No part of the enclosed CD or this book, including all source code, help files, shareware, freeware, utilities, example programs, or evaluation programs, may be made available on a public forum (such as a World Wide Web page, FTP site, bulletin board, or Internet news group ) without the express written permission of Wordware Publishing, Inc. or the author of the respective source code, help files, shareware, freeware, utilities, example programs, or evaluation programs.

  4. You may not decompile, reverse engineer, disassemble, create a derivative work, or otherwise use the enclosed programs, help files, freeware, shareware, utilities, or evaluation programs except as stated in this agreement.

  5. The software, contained on the CD and/or as source code in this book, is sold without warranty of any kind. Wordware Publishing, Inc. and the authors specifically disclaim all other warranties, express or implied, including but not limited to implied warranties of merchantability and fitness for a particular purpose with respect to defects in the disk, the program, source code, sample files, help files, freeware, shareware, utilities, and evaluation programs contained therein, and/or the techniques described in the book and implemented in the example programs. In no event shall Wordware Publishing, Inc., its dealers, its distributors , or the authors be liable or held responsible for any loss of profit or any other alleged or actual private or commercial damage, including but not limited to special, incidental, consequential, or other damages.

  6. One (1) copy of the CD or any source code therein may be created for backup purposes. The CD and all accompanying source code, sample files, help files, freeware, shareware, utilities, and evaluation programs may be copied to your hard drive. With the exception of freeware and shareware programs, at no time can any part of the contents of this CD reside on more than one computer at one time. The contents of the CD can be copied to another computer, as long as the contents of the CD contained on the original computer are deleted.

  7. You may not include any part of the CD contents, including all source code, example programs, shareware, freeware, help files, utilities, or evaluation programs in any compilation of source code, utilities, help files, example programs, freeware, shareware, or evaluation programs on any media, including but not limited to CD, disk, or Internet distribution, without the express written permission of Wordware Publishing, Inc. or the owner of the individual source code, utilities, help files, example programs, freeware, shareware, or evaluation programs.

  8. You may use the source code, techniques, and example programs in your own commercial or private applications unless otherwise noted by additional usage agreements as found on the CD.

    Warning 

    By opening the CD package, you accept the terms and conditions of the CD/Source Code Usage License Agreement.

    Additionally, opening the CD package makes this book nonreturnable.