Roland,

I don't see how this:

EdtMlsOfficeId.Text = Form01_Ds1.Personnel.MlsOfficeIdColumn.ToString

can work ... this syntax is not correct (I know VB is different from C#, but it still doesn't look right to me).

But, from what you've posted, it *does* look like you might be using Typed DataSets ... it this correct?

~~Bonnie


>Hi Bonnie and Cathi,
>
>
>The spaces did not show in the mail.
>EdtMlsOfficeId.Text = Form01_Ds1.Tables("Personnel").Rows(0)("MlsOfficeId")
>xxxxxxxxxxxxxxxxxxxxxx_____________________________________________________
>
>
>The follwoing seems to work.
>
>EdtMlsOfficeId.Text = Form01_Ds1.Personnel.MlsOfficeIdColumn.ToString
>
>PS. How do you get the white background to show instead of the gray in the
>mail?
>
>Thank you very much for help. Both Bonnie and Cathi!!!!!!!!!!!!!!!!!!!
>Roland
>
>===========================================================================
>>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