I am somewhat new to these .NET controls and was wondering if this is even possible, and if so can someone point me in the right direction. I have a web form that populates an affiliates account information into a DetailsView control on the form. Each affiliate only has one record with only a handful of columns that they will be able to update so this seemed like the right control to use.

I have the data populating and even edit/updating correctly, but what I want to do is also save the original data to a different table when a change is made. How can I compare changes made in the DetailsView edit, and more importanly - how do INSERT to a different table the data while still saving the changes the affiliate made. Make any sense?

Thanks in adavance for any help on this.

Hi there.. I think this can be easily done with a trigger, what database are you using?

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

I am using SQL Server 2K5, database named "db_WebTrans".

The table being updated is named "Affiliates", and the table I wish to write the changes made is called "Aff_Update". Very straight forward in that respect.

Well, I'm not a trigger expert (altough they work very similar to an SP), but if you add a triger in the update, you have the data that has been changed and the data that you add, and you can add the old data to the new table without problems.

IMHO you should be looking on how to put this in a trigger..

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

I am not familiar with this, so I write this directly into the SqlDataSource Update Query?

nop, inside the database.

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========