Daniel

Daniel

  • NA
  • 66
  • 0

TableAdapter Update statements..NEED HELP

Dec 12 2007 5:13 PM
I am using typed dataset that is populated by a query of a simple join between two tables

The DataSet wizard is NOT creating the update statements required to send the database back to the database.  I have read that the wizard cannot generate the update when more than one table is involved, which I found odd.  Is this true????

It seems I need to implement a custom update statement since the wizard can't.  I am new to using a typed dataset do not know how to do this.

Table A:
standard_id (PK)
standard_name

Table B:
req_id (PK)
Doc_Req_id,
Doc_Sub_Req_id
req_category
req_text
req_rationale
Standard_Id (FK to TableA.standard_id)

Here is my query that generates my dataset.  I am using TableA to get the name of the standard in TableB:
SELECT TableB.req_id, TableB.Doc_Req_id, TableB.Doc_Sub_Req_id, TableB.req_category, TableB.req_text, TableB.req_rationale, TableB.Standard_Id, TableA.std_name
FROM TableA LEFT JOIN TableB ON TableA.standard_id = TableB.Standard_Id;



THANKS IN ADVANCE FOR ANY HELP!!!!

Answers (1)