Roland,

From your earlier reply to me, I assumed your syntax error was in the way I said to specify the cast. Apparently not ... exactly what part of the statement has the blue underline?

~~Bonnie

>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