What now?...Dataset issue

  • Thread starter Thread starter Phil Lamey
  • Start date Start date
P

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;Persist
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
 
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
 
Back
Top