ansaurus

Question

VB .NET : DataGridView.DataMember throws error when assigned a two-part name. i.e. Sales.StoreContact

Answer 1

A:

Update: If your DataTable itself is called "Sales.SalesContact", you could try setting the DataGridView.DataSource property directly to the DataTable (instead of the DataSet):

Dim salesContactTable As DataTable = dataSet.Tables("Sales.SalesContact")
dataGridView.DataSource = salesContactTable

So you're saying you have a DataSet called "Sales", which contains a table called "SalesContact"?

Did you try setting your DataGridView.DataSource property to your "Sales" DataSet and DataGridView.DataMember to simply "SalesContact"?

Dan Tao 2010-09-15 12:30:26

Yes. Tried that.

2010-09-15 12:52:44

<NewDataSet> <Sales.SalesContact> <SalesContactID>1</SalesContactID> <Name>Jimmy</Name> <ReasonType>Damaged</ReasonType> <ModifiedDate>2010-01-05T00:00:00+00:00</ModifiedDate> </Sales.SalesContact> </NewDataSet>

2010-09-15 12:53:45

@user323186: I see. So your table itself is called "Sales.SalesContact"?

Dan Tao 2010-09-15 13:00:58

yes. exactly. any ideas?

2010-09-15 13:11:13

@user323186: Did you try my updated suggestion?

Dan Tao 2010-09-15 13:16:46

just tried that. unfortunately the same result. Child list for field SalesContact cannot be created. So to confirm I did it correctly I did: Dim salesContactTable As DataTable = dsTableContents.Tables("Sales.SalesContact"), then associated datasource to salesContactTable and datamember to SalesContact. Any other suggestions?

2010-09-15 14:18:37

@user323186: Sorry for all the failed attempts. But my suggestion was a *bit* different from what you just said; I was suggesting to set the `DataSource` to the table (as you did) **but leave `DataMember` blank**; don't assign it to anything. What happens when you try that?

Dan Tao 2010-09-15 14:26:27

Its looking good. Thank you very much. Strange tho, as i tried that before with the datasource and it didnt work, but fine when I used the dataTable. Would love to know why. But anywho, thank you.

2010-09-15 14:39:15

ansaurus

tags:

views:

answers:

VB .NET : DataGridView.DataMember throws error when assigned a two-part name. i.e. Sales.StoreContact

related questions