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