Index O

O

Object data type, 60, 61, 63

object instantiation (invoking classes), 111-116

object orientation, 16-18

ODBC .NET Data Provider, 19-20, 316

OLE DB .NET Data Provider, 19, 315

OLE Object data type (Access), 64

OleDbCommand class, 21, 327-332

configuring for browsing and data manipulation, 449

dynamic data access, 366-377

with Access query and parameters, 375-377

with SQL string and parameter, 372-375

with SQL string and variable, 367-368

validating string variables , 368-371

dynamic data manipulation, 378-388

adding database tables, 381-383

creating Access databases, 379-380

within transactions, 383-388

OleDbConnection class, 21, 321-327

database connections, 356-365

altering where to find database file, 363-365

connecting to SQL server databases, 360-363

reporting Connection properties, 357-359

deploying projects with connections, 324

dynamic data access, 366-377

with Access query and parameters, 375-377

with SQL string and parameter, 372-375

with SQL string and variable, 367-368

validating string variables, 368-371

dynamic data manipulation, 378-388

adding database tables, 381-383

creating Access databases, 379-380

within transactions, 383-388

OleDbDataAdapter class, 22, 337-343. See also data adapters

configuring, 448-450

programming, 388-411

setting up for data manipulation, 390-394

OleDbDataReader class, 21, 332-337

OleDbDataSet class, programming, 388-411

concurrency violations, 409-411

displaying dataset metadata and data, 394-398

graphically based datasets, 404-409

manipulating rows, 399-404

OleDbObjectSamples project (example), 321-343

OleDbParameter class, 372

OleDbPermission class, 571

OleDbType enumeration, 372-373

one-dimensional arrays, processing, 95-96

Open ( ) (OleDbConnection class), 322

opening forms. See modal vs. modeless forms

opening/closing class references, 46-47

operating system requirements for ADO.NET, 314

operational views of Web forms, 499-502

operational views of Windows forms, 444-445

optimistic currency, 319

Option Explicit statement, 72-73

Option Strict statement, 72-73

Optional keyword, 74-76

optional parameters in procedures, 74-76

Oracle, .NET Data Provider for, 316

OrderIDService project (example), 555-567

overloading, 16, 164, 178-179

Overloads keyword, 164

Overridable keyword, 48, 164, 166

Overrides keyword, 48, 164

overriding, 17, 48