Roland,
Row 0 refers to Row 0, not the current row.
You may need to cast the row's value, like this:
EdtMlsOfficeId.Text = (string)Form01_Ds1.Tables("Personnel").Rows(0)("MlsOfficeId")
~~Bonnie
>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