TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
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!!!!
Reply
Answers (
1
)
Insert not working???
Nested If and Try statements?