Connect and Retrieve Data in Oracle With VB.NET

Category:
Database
Type:
Modules
Difficulty:
Intermediate
Author:
Ravi Sankar

Version Compatibility: Visual Basic.NET

More information:
The code below lets you create a connection object by calling the checkdbconnect_net function, which you can keep in a module. The connection uses an ODBC datasource and creates an Oracle dataadapter. You can then fill it with a dataset and access the dataset rows for any items in the table.

Instructions: Copy the declarations and code below and paste directly into your VB project.

Declarations:

Code: