Bonnie,
I thought I had tried that, but I have wasted your time by not reading or transferring the code correctly. Forgive me.
What does the Rows(0) indicate?
That work great!!!!!!!!
Thanks
Roland
============================================================================
>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
>>