"Learnicus" <spamthis@nospam.com> wrote in message
news:eU65zlaQGHA.2692@TK2MSFTNGP14.phx.gbl...
> Hello
>
> I have a dataset which is successfully being filled. However whenever i
> try to access a givewn row of one of the tables in the dataset i get the
> error
>
> "Column 'ContactId' does not belong to table 'SalesAgent'"
>
> Except that it does and if i use an ordinal reference i can access the
> value of the column. If i print the schema sure enough the column is
> called ContactId. I have also noticed that if i hover the cursor over the
> contactrow i can access a treeview which lists all columns in the
> contactrow and then tells me that none of them belong to table salesagent.
>
> This was a conversion from 1.1 to 2.0. Any ideas?
>
> Thanks
> Lenny
>

"Miha Markic [MVP C#]" <miha at rthand com> wrote in message
news:eTpUuFcQGHA.1096@TK2MSFTNGP11.phx.gbl...
> Hi,
>
> How exactly are you accessing data? And where are your columns defined?
>
> --
> Miha Markic [MVP C#]
> RightHand .NET consulting & development www.rthand.com
> Blog: http://cs.rthand.com/blogs/blog_with_righthand/
>
> "Learnicus" <spamthis@nospam.com> wrote in message
> news:eU65zlaQGHA.2692@TK2MSFTNGP14.phx.gbl...
>> Hello
>>
>> I have a dataset which is successfully being filled. However whenever i
>> try to access a givewn row of one of the tables in the dataset i get the
>> error
>>
>> "Column 'ContactId' does not belong to table 'SalesAgent'"
>>
>> Except that it does and if i use an ordinal reference i can access the
>> value of the column. If i print the schema sure enough the column is
>> called ContactId. I have also noticed that if i hover the cursor over the
>> contactrow i can access a treeview which lists all columns in the
>> contactrow and then tells me that none of them belong to table
>> salesagent.
>>
>> This was a conversion from 1.1 to 2.0. Any ideas?
>>
>> Thanks
>> Lenny
>>
>
>

"Learnicus" <spamthis@nospam.com> wrote in message
news:udlBqEjQGHA.4264@TK2MSFTNGP11.phx.gbl...
> Hi Miha,
>
> The columns are defined as part of the strongly typed dataset schema. Im
> accessing the data as follows:
>
> If SalesTerritory.RelateSalesAgentsSalesTerritories(ds) Then
>    Dim contactRow As dsContact.ContactRow
>    contactRow =
> CType(activeTerritory.GetParentRow(SalesTerritory.RELATION_SAST), _
>    dsContact.ContactRow)
>    If contactRow Is Nothing Then
>        Me.lblSalesAgent.Text = "<Unknown>"
>    Else
>        Me.ViewState.Add("SalesAgentId", contactRow.ContactId)
>        Me.lblSalesAgent.Text = contactRow.ContactName
>    End If
> Else
>    Global_asax.DenyRequestInternalError()
> End If
>
> This fails at runtime on the line :Me.ViewState.Add("SalesAgentId",
> contactRow.ContactId).
> With the message as per the subject line. There is data in contactrow and
> contactrow is not equal to nothing. If i use clng(contactrow(0)) i can get
> the data and if i use contactRow("ContactId") i can get the data.
>
>
> Thanks
>
> Lenny
>
>
>
>
> "Miha Markic [MVP C#]" <miha at rthand com> wrote in message
> news:eTpUuFcQGHA.1096@TK2MSFTNGP11.phx.gbl...
>> Hi,
>>
>> How exactly are you accessing data? And where are your columns defined?
>>
>> --
>> Miha Markic [MVP C#]
>> RightHand .NET consulting & development www.rthand.com
>> Blog: http://cs.rthand.com/blogs/blog_with_righthand/
>>
>> "Learnicus" <spamthis@nospam.com> wrote in message
>> news:eU65zlaQGHA.2692@TK2MSFTNGP14.phx.gbl...
>>> Hello
>>>
>>> I have a dataset which is successfully being filled. However whenever i
>>> try to access a givewn row of one of the tables in the dataset i get the
>>> error
>>>
>>> "Column 'ContactId' does not belong to table 'SalesAgent'"
>>>
>>> Except that it does and if i use an ordinal reference i can access the
>>> value of the column. If i print the schema sure enough the column is
>>> called ContactId. I have also noticed that if i hover the cursor over
>>> the contactrow i can access a treeview which lists all columns in the
>>> contactrow and then tells me that none of them belong to table
>>> salesagent.
>>>
>>> This was a conversion from 1.1 to 2.0. Any ideas?
>>>
>>> Thanks
>>> Lenny
>>>
>>
>>
>
>