Index

A B C D E F G H I L M N O P Q R S T U V W

A

accounts

unlocking, 5.2, 8.3

Add() method, 4.3

adding references, 3.2

alias

database, 5.2

ALTER TABLE, 5.5

anonymous users

denying, 7.6

apply filters, 5.2, 8.3

ASP.NET Configuration, 7.5

ASP.NET tutorial, 7.2

ASP.NET user schema, 2.4.1

ASP.NET Web Sit Administration Tool, 7.5

ASPNET_DB_USER, 2.4.1

authentication

web site, 7.4

automatic naming, 3.1

B

before beginning ASP.NET tutorial, 7.2

bind variables

name, 4.3

position, 4.3

binding data, 4.5

building an ASP.NET Application with ODT, 7.1

building connection, 3.5

button control, 3.4

C

C# statements

using, 3.3

case statements, 3.7.3

class variables, 4.5

click events, 4.5

client globalization settings, 9.5.1

CLR (Common Language Runtime), 1.2

Code and Designer toggle, 3.4

Code view, 3.3

commands

query, 4.1

using, 4.1

CommandType property, 4.1

Common Language Runtime (CLR)

agent, 8.2

definition, 1.2

Service

starting, 8.2

configuration scripts, 2.4

configuring an OracleConnection window, 8.6

configuring Oracle Providers for ASP.NET

all, 2.4.1.2

individually, 2.4.1.3

connect alias, 2.3

connect descriptor, 2.3

connecting, 5.2

as SYSDBA, 8.3, 8.6

connecting web site to database, 7.3

connection

add, 8.3

building, 3.5

data source names, 5.2, 5.2, 8.3

details, 8.3

dispose, 4.5

hr, 8.3

name, 5.2

new, 8.3

opening, 3.5

password, 5.2, 5.2

role, 5.2

specific user name and password, 5.2

user name, 5.2, 8.3

user name and password, 8.3

connection control, 3.4

connection strings

setting for ASP.NET, 2.4.2

constraints

add, 5.5

properties, 5.5

tab, 5.5

controls, 3.4

button, 3.4

DataGrid, 4.4

Label, 3.4, 3.4

Listbox, 4.2

Textbox, 3.4

toolbox, 3.4

copying a form, B

creating a user, 2.4.1

creating a web site, 7.3

creating a web user, 7.5

creating an Oracle Project, 8.4

cultural conventions, 9.1

Culture parameter (ID), 9.4

CultureInfo object, 9.2

culture-sensitive data, 9.5

CurrentCulture parameter, 9.5.3

customizing Oracle Providers for ASP.NET, 2.4.3

D

data entry control, 3.4

data grid, 6.6

data provider, 3.2

Oracle Data Provider for .NET, 1.3

Data Source Configuration wizard, 7.3.2

data source names, 5.2, 8.3

database error messages, 3.7.3

DataGrid class, 6.6

DataGrid control, 4.4

DataReader class, 4.4

DataSet class, 4.5

updating, 9.5.2

date formats, 9.3.2

change, 9.5.2

default roles, 5.2

Default.aspx, 7.4

deleting data, 4.7

Design view, 5.3

Designer, 3.4

Designer and Code toggle, 3.4

designing user interfaces, 3.4

dialog

new projects, 3.1

Direction property, 4.3

display schema, 5.2, 8.3

Dispose() method, 3.7.1

documentation library, 1.1

E

enabling a web site for authentication, 7.4

enabling Oracle Providers for ASP.NET, 7.5

Enterprise Manager, 2.1.1, 8.6

error handling

exceptions with ODP.NET, 3.7

ODP.NET, 3.7

Oracle, 3.7

Try-Catch-Finally, 3.7.1

error messages, 9.3.5

Error property, 3.7

events

click, 4.5

examples

names of, 3.1

Exception class, 3.7.3

ExecuteReader() method, 4.2

F

FCL (Framework Class Libraries), 1.2

File menu, 3.1, 3.1

finally block, 4.5

foreign key, 5.5

Form1, 3.1

form1.cs, 3.1

form1.vb, 3.1

forms, 3.4

Framework Class Libraries (FCL)

definition, 1.2

G

GetSessionInfo() method, 9.5.2

GetThreadInfo() method, 9.5.3

global applications

development, 9.1

introduction, 9.1

.NET framework, 9.2

globalization

definition, 9.2

session information, 9.5.2

globalization support

client, 9.5

ODP for .NET, 9.5

granting privileges, 2.4.1

Grant/Revoke Privileges Wizard in ODT, 2.4.1

GridView control, 7.3

H

HR schema, 2.1.2

I

Imports statement, 3.3

indexes

add, 5.4

creating, 5.4

properties, 5.4

Indexes tab, 5.4

inserting data, 4.7

InstallOracleASPNETCommon.sql, configuration, 2.4

L

Label control, 3.4, 3.4

linguistic sorts, 9.3.4

ListBox, 4.2

local user conventions, 9.3

locale

awareness, 9.1

characteristics, 9.1

definition, 9.1

synchronizing, 9.4

localization

resources, 9.2

lock, 5.2, 8.3

M

machine.config, 2.4

memory location, 6.3

menus

File, 3.1, 3.1

View, 3.4

method parameters

binding, 6.6

definition, 6.6

methods

Add(), 4.3

Dispose(), 3.7.1

Open(), 3.5

Microsoft internationalization

URL, 9

Microsoft .NET Framework

definition, 1.2

Microsoft Visual Studio, 1.5

2005, 1.1

2008, 1.1

N

name of code files, 3.1

name of forms, 3.1

Name property, 3.4

namespace directives, 3.3

.NET assembly, 1.5

NET connect, 2.3

.NET languages, 1.4

.NET stored functions and procedures

creating, 8.5

deploying, 8.6

running, 8.7

.NET stored procedure, 1.5

.NET Stored Procedures, 2.1.1

.NET stored procedures, 1.4, 2.1.4

deployment, 8.2

.NET Types, 9.5.3

New Package Window, 6.4, 6.5

New Project dialog, 3.1

NLS error messages setting, 9.3.5

NLS number formats

settings, 9.3.3

NLS sort order, 9.3.4

NLS_LANG parameter, 9.5, 9.5.1

NLS_LANGUAGE parameter, 9.3.2, 9.3.5, 9.4

NLS_SORT parameter, 9.3.4

NLS_TERRITORY parameter, 9.3.2, 9.3.3, 9.4

O

ODAC (Oracle Data Access Components), 2.2

ODP.NET Types, 9.5.3

Open() method, 3.5, 9.5

opening connection, 3.5

Oracle Data Access Components (ODAC), 2.1.3

downloading, 2.2

Oracle Data Provider for .NET, 2.1.1

using, 4

Oracle Data Provider for .NET (ODP.NET)

definition, 1.3

globalization, 9.1

installation, 2.2

Oracle Database, 2.1.1

documentation library, 1.1

installation, 2.1.1

Oracle Database Extensions for .NET

installing, 2.1.4

upgrades, 2.1.4

Oracle date formats, 9.3.2

Oracle Deployment Wizard for .NET, 1.5, 8.6

Oracle Developer Tools

definition, 1.4

features

designer, 1.4

drag and drop, 1.4

dynamic help, 1.4

Oracle Data Window, 1.4

Oracle Query Window, 1.4

PL/SQL editor, 1.4

wizard, 1.4

installation, 2.2

using, 5.1

Oracle error messages, 9.3.5

Oracle linguistic sorts, 9.3.4

Oracle number formats, 9.3.3

Oracle Projects

creating, 8.4

Oracle Providers for ASP.NET, 2.4.1.2

configuring individually, 2.4.1.3

customizing, 2.4.3

enabling, 7.5

setup, 2.4

Oracle Universal Installer (OUI), 2.2

ORACLE_BASE\ORACLE_HOME, 2.2

OracleClrAgent service, 8.2

OracleCommand class, 4.1, 4.2, 4.3

using stored procedure, 6.6

OracleConnection class, 3.5, 9.5

GetSessionInfo() method, 9.5.2

Open() method, 9.5

OracleDataAccess.dll, 3.2

OracleDataReader class, 4.2, 4.2, 4.4, 4.5

OracleDbType property, 4.3, 4.3

OracleError class, 3.7

OracleErrorCollection class, 3.7

OracleException class, 3.7, 3.7.3

OracleGlobalization

class, 9.5.2

GetClientInfo() method, 9.5.1

OracleGlobalization class

GetThreadInfo() method, 9.5.3

SetThreadInfo() method, 9.5.3

OracleParameter class, 4.3, 6.6

OracleParameterCollection class, 4.3

OracleRefCursor class, 6.3

OracleService, A

OraProvCfg, 2.4

OUI (Oracle Universal Installer), 2.2

P

package bodies, 6.2

package interfaces, 6.2

PACKAGE types, 6.2

packages

new, 6.4, 6.5

ParameterName, 4.3

passwords

save, 5.2

PL/SQL packages

body, 6.2

definition, 6.2

interface, 6.2

introduction, 6.2

PL/SQL stored procedures

definition, 6.1

in ODP.NET, 6.6

introduction, 6.1

REF CURSORs, 6.4, 6.5

preview SQL, 5.3, 6.4, 6.5

primary key

column, 5.5

privileges

granting, 2.4.1

projects

add reference, 3.2

new, 3.1

solution, 3.1

type

Visual Basic, 3.1

Visual C#, 3.1

properties

Direction, 4.3

Error, 3.7

OracleDBType, 4.3

OracleDBType property, 4.3

ParameterName, 4.3

Size, 4.3

Value, 4.3

Properties window, 3.4

Q

query performance, 4.3

Query Window

running .NET procedures, 8.8

query work area

definition, 6.3

R

Rebuild Solution, 3.7.2

records, 4.7

add, 5.6

REF CURSORs

accessibility, 6.3

assigning, 6.4, 6.5

definition, 6.3

introduction, 6.3

PL/SQL data type, 6.3

PL/SQL stored procedures, 6.4, 6.5

references

adding, 3.2

result set, 6.3

retrieving data

accessor type, 4.2

bind variables, 4.3

from Oracle, 7.3

looping, 4.4

multiple columns, 4.4

multiple rows, 4.4

multiple values, 4.4

simple query, 4.2

value methods, 4.2

roles

user default, 5.2

Run Function window, 8.7

running .NET procedures in Query Window, 8.8

running .NET procedures in SQL, 8.8

S

sample data, 2.1.2

sample schemas, 2.1.2

Save command, 3.3

schema object, 1.4, 8.3

schemas

display, 5.2, 8.3

security, 7.1

SELECT statements

bind variables, 4.3

simple, 4.3

Server Explorer, 1.4, 6.5

using, 5.2

service_name, A

Services, A

session globalization setting, 9.5.2

SetThreadInfo() method, 9.5.3

setup for Oracle Providers for ASP.NET, 2.4

simple query, 4.2

Size property, 4.3

solution, 3.1

specify copy options window, 8.6

specify deployment option window, 8.6

specify methods and security details window, 8.6

SQL preview, 5.3

SQL query, 4.1

SQL statement string, 4.1

SQL*Plus, 9.3.2

connecting to, 9.3.1

sqlnet.ora, 2.3

start Oracle Database Instance, A

Start Without Debugging, 7.6

statements

case, 3.7.3

Imports, 3.3

optimizing, 4.3

parsing, 4.3

reusing, 4.3

using, 3.3

stop Oracle Database Instance, A

stored procedures

creating Oracle Project to hold, 8.4

definition, 6.1

run, 8.7

Summary

of deployment, 8.6

SYSDBA

connecting as, 8.6

System.Globalization, 9.2

System.Resources, 9.2

System.Threading.Thread.CurrentThread.CurrentCulture parameter, 9.5.3

T

table design views, 5.4

table design windows, 5.3

tables

add data, 5.6

constraint name, 5.5

constraint properties, 5.5

constraints, 5.5

add, 5.5

creating, 5.3

data, 5.6

grid, 5.6

new, 5.3

new relational, 5.3

query, 5.7

record, 5.6

relational, 5.3

retrieve data, 5.6

simple query, 5.7

testing

web site authentication, 7.6

Text property, 4.2

Textbox control, 3.4

thread-based globalization setting, 9.5.3

tnsnames.ora, A

configuring, 2.3

toolbox, 3.4

try code block, 4.1, 4.5

Try-Catch-Finally block, 3.7.1

Try-Catch-Finally error handling, 3.7.1

tutorial, 7.2

U

unlocking accounts, 5.2, 8.3

unlocking user account

Oracle Database interface, 8.6

updating data

bind variable, 4.3

user interfaces

designing, 3.4

user schema

ASPNET_DB_USER, 2.4.1

user_source view, 6.2

users

creating, 2.4.1

locale settings, 9.4

role, 5.2, 8.3

using statements, 3.3

V

Value property, 4.3

variable declarations, 4.5

View menu, 3.4

views

Design, 5.3

table design, 5.4

user_source, 6.2

Visual Basic (VB) statements

Imports, 3.3

Visual Studio, 1.5

versions, 2.1.5

W

warning

in error handling, 3.7

web site

connecting to database, 7.3

creating, 7.3

web site authentication, 7.4

testing, 7.6

web users

creating, 7.5

Windows Registry, 9.5, 9.5.1