TableAdapter Update statements..NEED HELP

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!!!!

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Arshad18y ago

Write this code under the update Button

SqlConnection con =new SqlConnection("data source=localhost; database=master;user id=sa;password=sa");

SqlCommand cmd=new SqlCommand();

cmd.CommandText="update Table A set whatevaer colum u need where TableA.standard_id = TableB.Standard_Id";

cmd.Connection=con;

con.Open();

cmd.ExecuteNonQuery();

con.Close();

Regards

Arshad Khan