What now?...Dataset issue

[Phil Lamey]

I have the code below that I am using to load a dataset
from and Oracle DB table called PARTNER (SNB).

I then wish to load the information into a drop down but I
am getting lost near the end of the code...I have it
clearly marked below.

Imports System.Data.OleDb

Public Class WebForm1
Inherits System.Web.UI.Page
Protected WithEvents drpPartners As
System.Web.UI.WebControls.DropDownList

Private Sub Page_Load(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles MyBase.Load
'Create the data connection.

Dim oleDbConn As New OleDb.OleDbConnection
("Provider=OraOLEDB.Oracle.1;Password=xxxxxx;Persi st
Security Info=True;User ID=xxx;Data Source=xxxxx")
Dim strSQL As String
strSQL = "SELECT PARTNER.PARTNER_NAME_01,
PARTNER.PARTNER_CD, PARTNER.PARTNER_TYPE_CD FROM
SNB.PARTNER PARTNER WHERE PARTNER.PARTNER_TYPE_CD = '03'
ORDER BY PARTNER.PARTNER_NAME_01"
Dim dbAdapt As New OleDb.OleDbDataAdapter(strSQL,
oleDbConn)
Dim dsPartners As New DataSet()
dbAdapt.Fill(dsPartners, "Partner")
'Display the table in a data grid using date binding

***Now here I am trying to follow an example I have
seen.***
'Dim rowNext As dsPartners.XXXX

****First: Intellisense does not seem to pick up and of
the tables I put in for dsPartners and No matter what I
put in for XXXX ...I get an error saying it is "undefined".
********

End Sub

End Class

**********I would greatly appreciate any help. I am
obviously new at .NET (with experience in ASP). However.
there must be something I am missing here.*****

Thanks,

Phil Lamey

[Aaron]

If you want to bind the data in the data set to a
datagrid try this :
DataGrid1.DataSource = dsPartners.Tables("Partner")

if you're doing a asp page put
datagrid1.databind
after that statement
Aaron

-----Original Message-----
I have the code below that I am using to load a dataset
from and Oracle DB table called PARTNER (SNB).

I then wish to load the information into a drop down but Iam getting lost near the end of the code...I have it
clearly marked below.

Imports System.Data.OleDb

Public Class WebForm1
Inherits System.Web.UI.Page
Protected WithEvents drpPartners As
System.Web.UI.WebControls.DropDownList

Private Sub Page_Load(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles MyBase.Load
'Create the data connection.

Dim oleDbConn As New OleDb.OleDbConnection
("Provider=OraOLEDB.Oracle.1;Password=xxxxxx;Pers ist
Security Info=True;User ID=xxx;Data Source=xxxxx")
Dim strSQL As String
strSQL = "SELECT PARTNER.PARTNER_NAME_01,
PARTNER.PARTNER_CD, PARTNER.PARTNER_TYPE_CD FROM
SNB.PARTNER PARTNER WHERE PARTNER.PARTNER_TYPE_CD = '03'
ORDER BY PARTNER.PARTNER_NAME_01"
Dim dbAdapt As New OleDb.OleDbDataAdapter(strSQL,
oleDbConn)
Dim dsPartners As New DataSet()
dbAdapt.Fill(dsPartners, "Partner")
'Display the table in a data grid using date binding

***Now here I am trying to follow an example I have
seen.***
'Dim rowNext As dsPartners.XXXX

****First: Intellisense does not seem to pick up and of
the tables I put in for dsPartners and No matter what I
put in for XXXX ...I get an error saying it is "undefined".********

End Sub

End Class

**********I would greatly appreciate any help. I am
obviously new at .NET (with experience in ASP). However.there must be something I am missing here.*****

Thanks,

Phil Lamey
.