Accessing Data In Dataset with OracleClient

Hi everyone

My problem is that i wanna save some values in textboxes from a dataset:

Code:

 Dim adapBuscar As New OracleDataAdapter(sQuery, Conn)
                    Dim dsBuscar As New DataSet
                    adapBuscar.Fill(dsBuscar)
                                                                             
                    For Each rFila In dsBuscar.Tables(0).Rows
                        txtLastName2.Text = rFila("APE1_CLI")
                        txtLastName.Text = rFila("APE2_CLI")
                    Next

But, nothing happen, the values not appear in my textboxes.

Help me please, i am using oracleclient. When i use SQL SERVER, that code works
fine.

First of all, your code will display values in the last row of the table in the
dataset only.

In case it is not displaying any value, I suggest you check if sQuery is correct
and if dsBuscar is getting populated.

Hi,

 
check this ....

--> Make a BreakPoint at Dataset in your code..
--> Start Debugging thru your code..
--> Check your dataset value (may be thru QuickWatch)..
--> Check Valule of Dataset->Table->List-> [0] -> Rows ->
Count

This Rows Count should be > 0 to populate desired Output.
if not then Insert test Records into your database table.

hope this help to find route cause.

thanks,
`````````````
j@y


-> Mark as answer if this helps you.