Roland,
Glad you finally got it working.
>What does the Rows(0) indicate?<
Ummmm .... probably Row 0. =)
~~Bonnie
>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
>>>