book

Programming Visual Basic .NET

by Dave Grundgeiger

December 2001

Beginner

464 pages

13h 51m

English

O'Reilly Media, Inc.

Read now

Unlock full access

Organization of This Book
What Is the Microsoft .NET Framework?
hello, worldHello, WindowsHello, Browser
Source Files

Numeric LiteralsString LiteralsCharacter LiteralsDate LiteralsBoolean LiteralsNothingSummary of Literal Formats
Fundamental TypesCustom TypesArraysInitializing arraysDynamically allocating arraysCollectionsType Conversions
The Namespace StatementThe Imports Statement
Variable Initializers
Unary OperatorsArithmetic OperatorsRelational OperatorsString-Concatenation OperatorsBitwise OperatorsLogical OperatorsOperator PrecedenceOperator Overloading
Option StatementsBranching StatementsCallExitGotoIfRaiseEventReturnSelect CaseIteration StatementsDoForFor EachMathematical FunctionsInput/Output
Object Instantiation and NewConstructorsFieldsRead-only fieldsHandling EventsInheritanceMethodsMethod parametersPassing arrays as parametersVariable-length parameter listsMain methodImplementing interface methodsOverriding inherited methodsOverloadingOverloading inherited methodsShadowingPropertiesThe Me and MyClass KeywordsThe MyBase KeywordNested ClassesDestructorsEarly Versus Late Binding
Boxing and Unboxing
Using Events and Delegates Together
Creating Custom AttributesReading Attributes
Common Language Infrastructure (CLI) and Common Language Runtime (CLR)
Namespaces
Global Assembly Cache (GAC)Comparison of Assemblies, Modules, and Namespaces
FinalizeDispose
Configuration File FormatConfiguration Section GroupsThe <appSettings> Section
Creating a FormCreating a Form Using Visual Studio .NETAdding event handlersCreating a Form in CodeAdding event handlers
Parent and Child FormsCreating a Window MenuMerging MenusDetecting MDI Child Window Activation
The Graphics ClassThe Pen ClassThe Brush ClassThe Color StructureSystem colorsAlpha BlendingAntialiasing
Hello, Printer!The PrintPageEventArgs ClassThe OnBeginPrint and OnEndPrint MethodsChoosing a PrinterThe PageSettings ClassThe PrinterSettings ClassPage Setup Dialog BoxPrint PreviewSummary of Printing
Common Controls and ComponentsThe Button ClassThe CheckBox ClassThe ComboBox ClassThe DateTimePicker ClassThe GroupBox ClassThe ImageList ClassThe Label ClassThe LinkLabel ClassThe ListBox ClassThe ListBox.ObjectCollection ClassThe ListView ClassThe MonthCalendar ClassThe Panel ClassThe PictureBox ClassThe RadioButton ClassThe TextBox ClassThe Timer ClassOther Controls and Components
The Anchor PropertyThe Dock PropertyControlling dock orderThe Splitter control
ColorDialogFontDialogOpenFileDialogPageSetupDialogPrintDialogPrintPreviewDialogSaveFileDialog
Adding Menus in the Visual Studio .NET Windows Forms DesignerProgrammatically Creating MenusHandling Menu EventsCloning Menus
Building Controls from Other ControlsBuilding Controls That Draw ThemselvesBuilding Nonrectangular Controls
Creating a Web FormCreating a Form Using Visual Studio .NETAdding event handlersCreating a Form in CodeSetting control properties using attributesAdding event handlers
AutoEventWireup
Web ControlsThe Button controlThe CheckBox controlThe DropDownList controlThe Image controlThe Label controlThe ListBox controlThe RadioButton controlThe Table controlThe TextBox controlOther web controlsHTML ControlsHandling Control EventsProgrammatically Instantiating Controls
More About Validation-Control Tag AttributesUsing Validation-Control PropertiesProviding a Summary View of Validation FailuresPerforming Custom Validation
The Server ObjectThe Application ObjectThe Session ObjectThe Cache ObjectThe Request ObjectThe Response Object
The Session ObjectThe Application ObjectCookies
Session and Application Startup and Shutdownglobal.asax Compiles to a ClassAdding Global Objects
AuthenticationForms authenticationWindows authenticationIntegrated Windows authenticationDigest authenticationBasic authenticationUnderstanding authenticationAuthorizationASP.NET authorizationWindows NTFS authorizationCode-access authorizationAccessing Network ResourcesIUSR_ComputerNameImpersonation
User ControlsServer ControlsCreating a custom server control using Visual Studio .NETCreating a custom server control in codeUsing a custom server control in Visual Studio .NETUsing a custom server control manually
Creating a Web ServiceThe WebService AttributeThe WebMethod AttributeThe WebService Class
Consuming a Web Service in Visual Studio .NETConsuming a Web Service in NotepadSynchronous Versus Asynchronous Calls
A Brief History of Universal Data Access
The DataSet ClassFinding TablesFinding RowsThe Select method versus the SQL SELECT statementFinding Column ValuesFinding Column DefinitionsChanging, Adding, and Deleting RowsWriting Updates Back to the Data Source
.NET Information

Content preview from Programming Visual Basic .NET

Chapter 8. ADO.NET: Developing Database Applications

Many software applications benefit from storing their data in database management systems. A database management system is a software component that performs the task of storing and retrieving large amounts of data. Examples of database management systems are Microsoft SQL Server and Oracle Corporation’s Oracle.

Note

Microsoft SQL Server and Microsoft Access both include a sample database called Northwind. The Northwind database is used in the examples throughout this chapter.

All examples in this chapter assume that the following declaration appears in the same file as the code:

Imports System.Data

Examples that use SQL Server also assume this declaration:

Imports System.Data.SqlClient

and examples that use Access assume this declaration:

Imports System.Data.OleDb

A Brief History of Universal Data Access

Database management systems provide APIs that allow application programmers to create and access databases. The set of APIs that each manufacturer’s system supplies is unique to that manufacturer. Microsoft has long recognized that it is inefficient and error prone for an applications programmer to attempt to master and use all the APIs for the various available database management systems. What’s more, if a new database management system is released, an existing application can’t make use of it without being rewritten to understand the new APIs. What is needed is a common database API.

Microsoft’s previous steps in this direction ...