I am currently almost complete with a PDA database that i have written in VB 2008.. However 2 problems still persist, i will start with what i think is the easiest to resolve.:
my database consists of the following columns:

date

provider

charge

allowed amount

discount

applied to deductible

co-pay

yearly deductible

maximum

other

payment

,,,,,,its a very simple database but remember it is a compact database(it does not have all the functionality of the full blown version) anyway
what i am attempting to do is read the database with the following sql command:
Dim cmdPayment As New System.Data.SqlServerCe.SqlCeCommand("SELECT Provider,Date,Payment FROM InsuranceTracker2008 WHERE payment is NOT NULL", conn)


so what i want to do here is read the database when Payment is NOT NULL then insert the following into a listbox
date, provider,payment????????? this is where i am stuck
I do not know how to parse the data and insert into list box?????

Thanks a bunch
m2m