how to put data from an oracle table into an object

de_swa
01-12-2004, 05:50 AM
How to put data from an oracle table into an object?

for example we have an oracle server with a table customers with custumor_id, first name, last name, ... as columns

how is it possible to get the data of 1 customer into an attribuut of the class named customer?

thanks in advance

de_swa
01-12-2004, 06:54 AM
Private Sub setupdata()
OleDbDataAdapter1.Fill(DataSet11, "Customers")

txtName.DataBindings.Add("text", DataSet11, "Customers.name")
' me.BindingContext(dataset11,
Dim klant As New customer()
customer.name = DataSet11.CUSTOMERS(0).NAME.ToString

txtName.Text = customer.name
End Sub

I already found this code which works
but is there an easier way the get the information into the class

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum