Column 'Column' does not belong to table 'Table'

L

Learnicus

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
 
M

Miha Markic [MVP C#]

Hi,

How exactly are you accessing data? And where are your columns defined?
 
L

Learnicus

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 said:
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 said:
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
 
L

Learnicus

From the immediate window:

?contactrow
{dsContact.ContactRow}
AKey: {"Column 'AKey' does not belong to table SalesAgent."}
ContactId: {"Column 'ContactId' does not belong to table SalesAgent."}
ContactName: {"Column 'ContactName' does not belong to table SalesAgent."}
ContactType: {"Column 'ContactType' does not belong to table SalesAgent."}
HasErrors: False
IPPassword: {"Column 'IPPassword' does not belong to table SalesAgent."}
IPUsername: {"Column 'IPUsername' does not belong to table SalesAgent."}
Item: In order to evaluate an indexed property, the property must be
qualified and the arguments must be explicitly supplied by the user.
ItemArray: {Length=9}
LastModified: {"Column 'LastModified' does not belong to table SalesAgent."}
RowError: ""
RowState: Added {4}
SinkState: {"Column 'SinkState' does not belong to table SalesAgent."}
SiteId: {"Column 'SiteId' does not belong to table SalesAgent."}
Table: {dsContact.ContactDataTable}
?contactrow(0)
13167 {Long}
Long: 13167 {Long}
?contactrow("ContactId")
13167 {Long}
Long: 13167 {Long}
?contactrow("Akey")
"DIKE" {String}
String: "DIKE"

?contactrow.Table
{dsContact.ContactDataTable}
dsContact.ContactDataTable: {dsContact.ContactDataTable}
CaseSensitive: False
ChildRelations:
{System.Data.DataRelationCollection.DataTableRelationCollection}
Columns: {System.Data.DataColumnCollection}
Constraints: {System.Data.ConstraintCollection}
Container: Nothing
DataSet: {dsSalesTerritory}
DefaultView: {System.Data.DataView}
DesignMode: False
DisplayExpression: ""
ExtendedProperties: Count = 0
HasErrors: False
IsInitialized: True
Locale: {System.Globalization.CultureInfo}
MinimumCapacity: 50
Namespace: "http://myco/myprod/dsSalesTerritory.xsd"
ParentRelations:
{System.Data.DataRelationCollection.DataTableRelationCollection}
Prefix: ""
PrimaryKey: {Length=0}
RemotingFormat: Xml {0}
Rows: {System.Data.DataRowCollection}
Site: Nothing
TableName: "SalesAgent"



Lenny

Learnicus said:
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 said:
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 said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top