R
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,
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,