I'm able to connect to a database and put information into a dataset object. How can I take information from the database and put it into a string for example.

so, to explain better, Let's say I have a table of people in the database and in my vb program I defined a class called people. I want to create a collection of people to use in my program, I want to create people objects and fill their first and last name properties from what is in the database.

am I going about this the wrong way? Let me know! thanks.:D

-Brian O'Neill

It depends on the broad overview of what you are trying to accomplish.
Could you expand on your question?

yeah, Im sorry im new to this and im having trouble explaining.

I have a database built with access. I can make an OLeDBconnection to the database.

I want to get data out of a table (example: names of people in a table of people) and save it as a string.

-Brian O'Neill

open a recordset like
"select people from table_of_people"
then loop through it:

.movefirst
dim result as string
do
if .eof the exit do
result = result + " " + .field("people").value
.movenext
loop

Marco

Thanks!

-Brian O'Neill