UpdateCommand

[Guest]

Hi.
In a WinForms App, I have a DataGridView. My SELECT command uses data from
Table A in a SQL Server database plus 4 calculated columns using data from
tables TableB and TableC. This works OK. The calculated values are not
stored in TableA, of course. I seem to have problems with updating my
TableA: VS2005 does not automacically generate an update command, because
multiple tables are involved. I want only to update what belongs to TableA,
the other tables are not modified. What is the best way for me to proceed?
Any suggestions, examples etc. will be appreciated.

Regards,
Gudni

 

[William \(Bill\) Vaughn]

I just posted a 20-page whitepaper to my book's premium site that
illustrates how to do this.
Basically, you need to go into the TableAdapter designer and reconfigure the
TableAdapter to call your own stored procedures when it's time to Insert,
Update or Delete a row. These routines can do whatever you need to get done
(as long as they return "1 rows affected").

hth
--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)