Hi Roland,

The Rows(0) is the Rows collection class of the DataTable. The zero is the first row of the collection. All collections in .NET are zero based so to retrieve the 5th row, you would use Rows(4). A DataRow object is returned and from there you can retrieve each of the fields in the DataRow.

>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
>>>