|
|
|
|
|
|
|
|
|
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
Inheritance and polymorphism
Development of a small object-oriented application
|
|
|
|
|
|
This appendix provides a definition of normalization and explains the process of normalization.
|
|
|
|
|
|
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
|
|
|
|
|
|
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. |
|
|
|
|
|
|
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
|
|
|
|
|
|
CD Content
The CD-ROM included with this book contains examples that
| 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. |
Please read the following CD/Source Code usage license agreement before opening the CD and using the contents therein:
By opening the
The compilation of code and utilities contained on the CD and in the book are
No part of the
You may not decompile, reverse engineer, disassemble, create a derivative work, or
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
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
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.
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. |
|
|
|