Hi Wim,
It is not impossible to use a recordset, but strongly advices to do not.
With a dataset you can do the same as with a recordset. It is not so often
given as example, but I think the example I give you bellow works even
better than a recordset. This is an example as addition to Eric, but there
are so much possibilities to handle data, that I don't think there is
someone who knows them all.
I want to be able to create a recordset and go forward
and backwords through it and us it in while not .EOF
structure as I did befor in VB6.
Another example than EricJ
dim i as integer = currentrow
for a next
\\\\
if ds.tables(0).rows(i) < ds.tables.rowscount then
myitem = ds.tables(0).rows(i+1)("mydatabaseItem")
end if
///
for a previous
if i>0
myitem = ds.tables(o).rows(i-1)("mydatabaseItem")
end if
///
I think the rest you understand.
I hope this helps a little bit?
Cor