Roland,
Forgive me for being so dense, but I'm still trying to figure out exactly what it is you're trying to do. Maybe you're asking two different questions in one thread?
Are you trying to set a variable equal to a column value from your DataSet? If so, you should do what I first posted, which was:
sAddress = ds1.Tables("Customer").Rows(0)("Name").ToString()
-- or the Typed DataSet equivalent
sAddress = ds1.Customer(0).Name
But, maybe you're trying to set a textbox equal to a column value from your DataSet (the second thing you mentioned), in which case I have to ask why you're aren't using data binding?
~~Bonnie
>Bonnie,
>
>Your right!!!
>
>It gives me the field name not the value.
>
>No syntax errors but just one step backwards!
>
>Any suggestions?
>
>Thanks
>Roland
>