Here is the code to display the contents of the table in oracle in a DataGrid control in Visual Basic 2008....
Initally declare the following code in the "General Declarations."
Imports Oracle.DataAccess.Client
Then use a command button to initiate the process of displaying the contents in data grid from the table(in its click event),
Dim oradb As String = "user id=tiger;password=tiger;data source=localhost"
Dim conn As New OracleConnection()
conn.ConnectionString = oradb
conn.Open()
Dim sql As String = "select * from stu" ' Visual Basic
Dim cmd As New OracleCommand(sql, conn)
cmd.CommandType = CommandType.Text
DataGridView1.DataSource = conn.DataSource
Dim da As OracleDataAdapter
Dim cb As OracleCommandBuilder
Dim ds As DataSet
da = New OracleDataAdapter(cmd)
cb = New OracleCommandBuilder(da)
ds = New DataSet()
da.Fill(ds)
DataGridView1.DataSource = ds.Tables(0)
