Index

O

Object data type, described, 78

Object Explorer, IDE, 42, 43

object members, 156. See also members. class members comparison, 484

object-oriented programming. See OOP

objects. See also OOP (Object-Oriented Programming).

ADO.NET, 853–854

comparing via Is keyword, 502–503

creating. See Dim statements (creating objects).

defined, 66, 481

Nothing keyword, 515

OleDbAdapter objects

WebDataGrids coding example, 977

WebServ coding example, 1068

OleDbCommand class, 931–932, 941–942. See also coding databases.

Cancel method, 942

CommandText property, 941

CommandTimeout property, 941

CommandType property, 941

Connection property, 931, 941

CreateParameter method, 942

DesignTimeVisible property, 941

ExecuteNonQuery method, 932, 942

ExecuteReader method, 932, 942

ExecuteScalar method, 932, 942

Open method, 931

Parameters property, 941

Prepare method, 942

ResetCommandTimeout method, 942

Transaction property, 941

UpdatedRowSource property, 941

OleDbConnection class, 929–931, 939–940. See also coding databases.

ADO.NET, 836

BeginTransaction method, 939

ChangeDatabase method, 939

Close method, 939

Connection property, 930

ConnectionString property, 930, 939

ConnectionTimeout property, 939

CreateCommand method, 939

Database property, 939

DataSource property, 939

GetOleDbSchemaTable method, 939

InfoMessage event, 940

Open method, 930, 939

Provider property, 939

SelectCommand property, 931, 932

Server Explorer, 841

ServerVersion property, 939

State property, 939

StateChange event, 940

OleDbDataAdapter class, 932–933, 945. See also coding databases.

Data Adapter Configuration Wizard, 845

databases, 850

DeleteCommand property, 945

Fill method, 933, 945

InsertCommand property, 945

MS Jet database, 876

ParameterizedQueries coding example, 902–903, 919

RowUpdated event, 945

RowUpdating event, 945

SelectCommand property, 945

Server Explorer, 841

Update method, 933

UpdateCommand property, 945

OleDbDataReader class, 935, 948–949. See also coding databases.

Close method, 949

Depth property, 948

FieldCount property, 948

GetBoolean method, 949

GetByte method, 949

GetBytes method, 949

GetChar method, 949

GetChars method, 949

GetDataTypeName method, 949

GetDateTime method, 949

GetDecimal method, 949

GetDouble method, 949

GetFieldType method, 949

GetFloat method, 949

GetGuid method, 949

GetInt16 method, 949

GetInt32 method, 949

GetInt64 method, 949

GetName method, 949

GetOrdinal method, 949

GetSchemaTable method, 949

GetString method, 949

GetValue method, 949

GetValues method, 949

IsClosed property, 948

IsDBNull method, 949

Item property, 948

Read method, 949

RecordsAffected property, 948

On Error Goto statements, unstructured exception handling, 118–119, 137–138, 142, 144

On Error Resume line statements, unstructured exception handling, 141–142

On Error Resume Next statements, unstructured exception handling, 141–142

onblur attribute, HTMLControls coding example, 814

onclick attribute, embedding VB code in Web pages, 653

onclick event, client event handling, 640–642

OnContinue event handler, Windows services, 1059

OnContinue method, ServiceBase class, 1080

OnPause event handler, Windows services, 1059

OnPause method, ServiceBase class, 1080

OnPowerEvent method, ServiceBase class, 1080

OnShutdown method, ServiceBase class, 1080

OnStart event handler, Windows services, 1059, 1061–1062

OnStart method, ServiceBase class, 1080

OnStop event handler, Windows services, 1059, 1061–1062

OnStop method, ServiceBase class, 1080

OOP (Object-Oriented Programming), 479–560. See also Visual Basic .NET.

abstraction, 485

class libraries, 516–518

class members, 481–483

class members versus object members, 484

class (shared) properties, 509

Class statements, 492–493

classes, 481

coding example, 487–490

ComboBoxesData coding example, 487–490

constructors, 486

creating class libraries, 516–518

creating class (shared) data members, 504–505

creating class (shared) events, 513

creating class (shared) methods, 507–508

creating classes, 492–493

creating constructors, 501–502

creating data members, 503–504

creating destructors (Finalize method), 487, 519

creating events, 510–513

creating methods, 506–507

creating modules, 500–501

creating namespaces, 518

creating properties, 508–509

creating structures, 497–500

data members, 482

destructors (Finalize method), 487, 519

Dim statements (creating objects), 493–496

encapsulation, 485

Event statements, 510–513

events, 483, 510–513

fields, 482

Finalize method (creating destructors), 487, 519

Friend keyword, 481, 482

inheritance, 485, 521–560

instance members, 484

Is keyword, 502–503

methods, 483, 506–508

Module statements, 500–501

modules, 500–501

modules and structures, 490–491

namespaces, 518

new features of Visual Basic .NET, 17, 20

New keyword, 486

Nothing keyword, 515

objects, 481

overloaded members, 485

overloading methods and properties, 513–515

overridden members, 485

overview, 480–483

polymorphism, 485

Private keyword, 481, 482

properties, 483, 508–509

Protected Friend keyword, 481, 482

Protected keyword, 481, 482

Public keyword, 481, 482

reference-tracing garbage collection, 487

shadowed members, 486

Shared keyword, 484, 504–505

shared members, 484

static members, 484

Structure statements, 497–500

structures and modules, 490–491

triggering garbage collection, 515

Open method

File class, 601

OleDbCommand class, 931

OleDbConnection class, 930, 939

SqlConnection class, 940

OpenFile method

OpenFileDialog class, 384, 406

SaveFileDialog class, 384, 409

OpenFileDialog class, 383–384, 405–408. See also Control class; dialog boxes.

AddExtension property, 406

CheckFileExists property, 406

CheckPathExists property, 406

DefaultExt property, 406

FileName property, 384, 406, 407

FileNames property, 406, 407

FileOK event, 407

Filter property, 383–384, 406, 407

FilterIndex property, 406

HelpRequest event, 407, 408

InitialDirectory property, 406, 407

MultiSelect property, 383, 406, 407

OpenFile method, 384, 406

public events, 407

public methods, 406

public properties, 406

ReadOnlyChecked property, 383, 406

Reset method, 406

RestoreDirectory property, 406

scrolling images, 350

ShowDialog method, 406

ShowHelp property, 406, 408

ShowReadOnly property, 383, 406

Title property, 406, 408

ValidateNames property, 406

opening or creating files, FileStream class, 592–593

OpenRead method, File class, 602

OpenText method, File class, 602

OpenWrite method, File class, 602

Operator property, CompareValidator class, 785

operators, 88–93

Arithmetic, 89

Assignment, 89

combination, 91

Comparison, 89–90

Logical/Bitwise, 90

miscellaneous, 90

precedence of, 91–93

Option statements, 67–68. See also statements.

Option Strict keyword, data type conversion, 79

Optional keyword, procedures, 129

ORDER BY clause, SELECT statements, 857

Ordinal property, DataColumn class, 955

Orientation property, TrackBar class, 335, 359

OtherMonthDayStyle property, Calendar class, 794

outer joins, SELECT statements, 859

Output window, IDE, 50, 51

overloaded members

inheritance, 527

OOP (Object-Oriented Programming), 485

overloading base class members, 548–549. See also inheritance.

Overloads keyword, 548

overloading methods and properties, 513–515. See also OOP (Object-Oriented Programming).

Display method, 514

Overloading coding example, 514

Overloads keyword, 514

Overloads keyword

inheritance, 528

overloading base class members, 548

overloading methods and properties, 514

SetBounds method, 173

Sub procedures, 122

Overridable keyword, 528, 552. See also inheritance.

overriding base class members, 545

Sub procedures, 122

overridden members

inheritance, 528

OOP (Object-Oriented Programming), 485

Overrides keyword

overriding base class members, 545

Sub procedures, 122

Overrides modifier, inheritance, 528

overriding base class members, 545–546. See also inheritance.

Overridable keyword, 545

Overrides keyword, 545

OverwritePrompt property, SaveFileDialog class, 409, 410

owned forms, 194–195

AddOwnedForm method, 194

OwnedForms property, Form class, 158

Owner property, Form class, 158

OwnerDraw property, MenuItem class, 391, 399