Pulling Information Using Table Name

Home

Reviews

ODP.NET

Table of Contents

ODP.NET - Retrieving Multiple Rows on to the Grid

Pulling Information Using Table Name

Page 2 of 2

Author: Packt Publishing Published on: 5th Apr 2008 | Last Updated on: 9th Apr 2008

ODP.NET - Retrieving Multiple Rows on to the Grid

Pulling Information Using Table Name

In all of the previous examples, the SELECT statement was used to retrieve a set of rows. The SELECT statement is a good choice if you would like to retrieve only specific columns or to include some complex combinations using sub-queries, joins etc.

Ads

You can also retrieve a complete table (without using a SELECT statement) by setting the CommandType of OracleCommand to TableDirect. The following code demonstrates the use of TableDirect:

Sample Code

Imports Oracle.DataAccess.Client
Public Class Form2
Private Sub btnGetEmployees_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
btnGetEmployees.Click
'create connection to db
Dim cn As New OracleConnection("Data Source=xe; _
User Id=scott;Password=tiger")
Try
Dim SQL As String
'build the SELECT statement
Dim cmd As New OracleCommand("emp", cn)
cmd.CommandType = CommandType.TableDirect
cmd.Connection.Open()
...
End Sub
End Class

Ads

The default CommandType is Text, which accepts any SQL statement. When we change it to TableDirect, it accepts only a table name. Another command type available is StoredProcedure. It is mainly used when you want to execute stored procedures using an OracleCommand object. (Working with PL/SQL stored procedures is covered in Chapter 5.)

1 2

Read Next: ODP.NET - Retrieving Typed Data

This tutorial is part of a ODP.NET tutorial series. Read it from the beginning and learn yourself.

ODP.NET