Bonnie,

Iam using SQLDataAdapter using the WinForms Adapter Wizards to generate the dataset code. I guess that it may be a Typed DataSet. I not sure. Iam a beginner!

Thanks
Roland

==========================================================================

>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