Hi Cathi,

getting syntax errors; blue underlines.

EdtMlsOfficeId.Text = Form01_Ds1.Tables("Personnel").Rows(0)("MlsOfficeId")
_____________________________________________________

DataSet is Form01_Ds in solutions explorer
and Form01_Ds1 below Form with SqlDataAdapter1 and SqlConnection1.

MlsOfficeId is in Personnel Table

DataSet contains Personnel Table with Office Table from query builder.

Any suggestions?

Thanks
Roland
=========================================================================

>Hi Roland,
>
>What is not working? Are you getting an error? If so, what is the error message?
>
>>Hi again,
>>
>>The following does not seem to work either.
>>
>> EdtMlsOfficeId.Text = Form01_Ds1.Tables("Personnel").Rows(0)("MlsOfficeId")
>>
>> sdMlsOfficeId = Form01_Ds1.PersonnelRow.("MlsOfficeId")
>>
>>The query builder includes fiels from 2 tables. Fields are from both tables.
>>
>>Any advise?
>>
>>Thanks
>>Roland
>>========================================================================
>>
>>>Hi,
>>>
>>>Does the Rows(0) indicate the current row or row 0 of the dataset?
>>>
>>>Thanks
>>>Roland
>>>===================================================
>>>
>>>>Its almost the same. VB uses () instead of []
>>>>
>>>>sAddress = ds1.Tables("Customer").Rows(0)("Name")
>>>>
>>>>
>>>>
>>>>>I don't do VB, but I'm pretty sure the syntax is the same for VB as it is for C#.
>>>>>
>>>>>Regular DataSet :
>>>>>

>>>>>sAddress = (string)ds1.Tables["Customer"].Rows[0]["Name"]
>>>>>
>>>>>-or-
>>>>>
>>>>>sAddress = ds1.Tables["Customer"].Rows[0]["Name"].ToString()
>>>>>

>>>>>
>>>>>Typed DataSet :
>>>>>

>>>>>sAddress = ds1.Customer[0].Name
>>>>>

>>>>>
>>>>>
>>>>>HTH,
>>>>>~~Bonnie
>>>>>
>>>>>
>>>>>
>>>>>>Hi,
>>>>>>
>>>>>>Using VB.net
>>>>>>WinForm
>>>>>>SqlAdapter
>>>>>>
>>>>>>How do you reference a DataSet Field Name directly in code to fill a variable?
>>>>>>
>>>>>>The following lines do not work.
>>>>>>
>>>>>>Public sAddress AS String
>>>>>>
>>>>>>sAddress = Ds1.Customer.Name
>>>>>>sAddress = Customer.Name
>>>>>>sAddress = Name
>>>>>>
>>>>>>What is the proper code?
>>>>>>
>>>>>>Thanks
>>>>>>roland