muchas gracias
jejeje
ya le he investigado econtre esto en internet, Then in an ADO application there is some function that moves among the Recordset getting data from each record and field combination. This would typically be accomplished using calls to the Recordset MoveFirst, MoveLast, MovePrevious, and MoveNext methods. For Example:
If rs.EOF = False Then
If rs.BOF = True Then
rs.MoveFirst
End If
rs.MoveNext
End If
If rs.EOF = False Then
FillDataFields
End If
Then data would be extracted from each current record in a Recordset using individual field accessors. For Example:
Flds = dataset
For Each fld In Flds
FieldSize = fld.ActualSize
If FieldSize > 0 Then
Select Case fld.Name
Case "EmployeeID"
txtEID.Text = Str(fld.Value)
Case "LastName"
txtLastName.Text = fld.Value
Case "FirstName"
txtFirstName.Text = fld.Value
Case "Title"
txtTitle.Text = fld.Value
...
End Select
End If
Next
In this example, the DataSet Table "Employee" is specifically assigned to a DataView and the resulting DataView iterated over to extract the data values. By using a DataView you can turn any table in a DataSet into an object that functions similarly to the old ADO Recordset.
lo voy a probar a ver que pasa, pero gracias por su ayuda