There is some documentation in MSDN that covers this. The magic happens in the Parameter class (SqlParameter in this case). You will want to set the SourceColumn and SourceVersion (original or modified). I know it is covered extensively in my upcoming book, but you can't wait till September. Hopefully Bob Beauchemin will reply and tell us whether it is covered in his book.
Thanks, Shawn Wildermuth [EMAIL PROTECTED] > -----Original Message----- > From: dotnet discussion [mailto:[EMAIL PROTECTED]] > On Behalf Of Rolls, Robert > Sent: Monday, May 27, 2002 12:57 AM > To: [EMAIL PROTECTED] > Subject: [DOTNET] Dataset and Updates. > > > Hi all, > > How do I achieve the same as the SQLCommandBuilder in other > words how do I know what SQL statement to produce given a > row. What columns have changed etc. > > > Regards, > Robert Rolls > > > > > ************************************************************** > ********" > This correspondence is for the named person's use only. It > may contain confidential or legally privileged information or > both. " No confidentiality or privilege is waived or lost by > any " mistransmission. If you receive this correspondence in > error, please immediately delete it from your system and > notify the sender. You must not disclose, copy or rely on > any part of this correspondence if you are not the intended recipient. > > Any views expressed in this message are those of the > individual sender, except where the sender expressly, and > with authority, states them to be the views of Vodafone. > > This email has been checked for viruses. > ************************************************************** > ******************************** > > You can read messages from the DOTNET archive, unsubscribe > from DOTNET, or subscribe to other DevelopMentor lists at > http://discuss.develop.com. > You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com.
