Updating a BindingSource that uses a Join!

[Rob Dob]

Hi,

I have both a Customer and a Orders Table, the key field is CustomerID. I
also have a DataGrid that uses a BindingSource which uses a dataset which
uses a join between the Customers table and the Orders table. Everything
displays correctly and when I double click on a row within the datagrid I
then open up a tabbed form that contains a detailed view of the record
selected. The user at this point is able to make changes to the record and
they are properly propogated back to the BindingSource. The problem is that
the TableAdapter does not contain the appopriate update, New SQL in order to
perform the update, therefore I am not able to call the TableAdapter.Update
method with the dataset as I would had I created a tableadapter not using a
join.

How am I best to handle this situation.

Thanks,

[Cor Ligthert [MVP]]

Rob,

The answer is very simple, the table adapter is build to update one real
table, not a joined datatable.

This needs in my opinion an other approach,

Does not help, however maybe fine to know.

Cor

"Rob Dob" <ro************@yahoo.comschreef in bericht
news:uC**************@TK2MSFTNGP04.phx.gbl...

Hi,

I have both a Customer and a Orders Table, the key field is CustomerID. I
also have a DataGrid that uses a BindingSource which uses a dataset which
uses a join between the Customers table and the Orders table. Everything
displays correctly and when I double click on a row within the datagrid I
then open up a tabbed form that contains a detailed view of the record
selected. The user at this point is able to make changes to the record
and they are properly propogated back to the BindingSource. The problem
is that the TableAdapter does not contain the appopriate update, New SQL
in order to perform the update, therefore I am not able to call the
TableAdapter.Update method with the dataset as I would had I created a
tableadapter not using a join.

How am I best to handle this situation.

Thanks,

[Rob Dob]

Hi,

The answer is very simple, the table adapter is build to update one real
table, not a joined datatable.

This needs in my opinion an other approach,

I understand this, but is there a way to post the updates of my databound
controls back to my two tables referred to within my bondingsource created
using a join. Basically the reason I'm using a join is that I want to
display both information from the orders table and customer table within my
dataview.

Thanks.

[Mel]

No, you must save the changes yourself individually to each table without
using the join.

"Rob Dob" <ro************@yahoo.comwrote in message
news:ub**************@TK2MSFTNGP04.phx.gbl...

Hi,

>The answer is very simple, the table adapter is build to update one real
table, not a joined datatable.

This needs in my opinion an other approach,

I understand this, but is there a way to post the updates of my databound
controls back to my two tables referred to within my bondingsource created
using a join. Basically the reason I'm using a join is that I want to
display both information from the orders table and customer table within
my dataview.

Thanks.

[Rob Dob]

Hi,

No, you must save the changes yourself individually to each table without
using the join.

Can I import the contents of fields with matching names from my
bindingsource to the two appropriate dataset that belong to each of my two
tables? What is the recommended approach to doing this?

Or is there a way to maybe display the contents of two different tables
within my one datagridview

Thanks,