Installing Oracle Developer Tools

Before proceeding with these steps to install Oracle Developer Tools for Visual Studio .NET, you must have a full installation of Oracle Database XE or the Oracle XE client alone, and Visual Studio .NET 1. In your Internet browser, navigate to the following software download location index.html 2. Download the setup.exe file to your desktop. 3. Double-click the Setup icon. The InstallShield Wizard will be launched. Oracle Developer Tools for Visual Studio .NET for Oracle Database Express...

Copying a Project

For this chapter, you need to use the application developed in Chapter 3, Connecting to the Database. Follow these steps to copy the project to a new directory. 1. Complete all steps in Chapter 3, Connecting to the Database. 2. Using the Windows Explorer, navigate to the directory C HR Visual Studio Projects. Make a copy of the entire folder HR_Connect_CS HR_Connect_VB for Visual Basic , and rename the new folder HR_ODP_CS HR_ODP_VB for Visual Basic . 2. Using the Windows Explorer, navigate to...

Deploying NET Stored Functions and Procedures

Follow these steps to deploy a .NET Stored Procedure 1. From the Build menu, select Deploy Solution. An Oracle Deployment Wizard for .NET window appears. 2. In the Oracle Deployment Wizard for .NET window, click Next. 3. On the Configure Your Connection window, click New Connection. 3. On the Configure Your Connection window, click New Connection. 4. You must now establish a connection with SYSDBA privileges. For the Data Source Name, use Local Database . For Password, enter the current sys...

Example 418 Using Data Set Class Declaring Variables VB

Private cmd As OracleCommand Private da As OracleDataAdapter Private cb As OracleCommandBuilder Private ds As DataSet HR_DataSet_ODP_CS - Microsoft Visual Cff .NET design - Forml .cs File Edit View Project Build Debug lools Window Help private OracleConnection conn new OracleConnection private OracleCommand cmd private OracleDataAdapter da private OracleCommandBuilder cb private DataSet ds 11. Within the Form method, add the code shown in Example 4-19 and Example 4-20. Example 4-19 Disabling...

Example 822 Changing the Date Format and Updating the Data Set VB

Si.DateFormat YYYY-MM-DD conn.SetSessionInfo si departments.DataSource ds.Tables 0 12. Save Forml using Ctr S keyboard shortcut. 13. Run the application using the F5 keyboard shortcut. 14. After you successfully connect to the database, the data grid is populated with the results of the query. Click Change Date Format. 15. Note that the date format is changed from the original DD-MON-RR to YYYY-MM-DD. Thread-based globalization parameter settings are specific to each thread. Initially, these...

Starting the Common Language Runtime Service

To use .NET Stored Procedures, you must first start the XE Common Language Runtime agent, represented by the OracleXEClrAgent service. This service may not start by default. Note that it is located on the Oracle XE database server, not on the client. 1. From the Start menu, select All Programs, then select Administrative Tools, and Component Services Computer Management J Data Sources ODBC IT Event Viewer 1 Microsoft .NET Framework 1.1 Confii 1 Microsoft .NET Framework 1.1 Wizar 2. In the...

Client Globalization Support in Oracle Data Provider for NET

Oracle Data Provider for .NET enables applications to manipulate culture-sensitive data, such as ensuring proper string format, date, time, monetary, numeric, sort order, and calendar support using culture conventions defined in the Oracle Database XE. The default globalization settings are determined by the client's NLS_LANG parameter, which is defined in the Windows Registry of the local computer. When the OracleConnection call Open establishes a connection, it implicitly opens a session with...