Viewing file: index.htm (50.02 KB) -rw-rw-rw- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
Index
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
- login.aspx, 7.4
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
|