SqlDataSource UpdateCommand plus Insert

[renatois]

SqlDataSource UpdateCommand plus Insert

I have a SqlDataSource with an UpdateCommand but besides that i need also an Insert command triggered on the same update command.

That´s because i need to update a record and at the same time include a log of that update in another database.

Thanks

[lotuzwine]

What you need is to create a transaction. A transaction is a list of db commands that will only true happen when the transaction is commited. Example, your Update command will happen but the results will be cached, it will not be stored your db until the transaction is commited. So you will only commit this transaction after your insert. I cant provide codes because of the framework we use here but try looking for ".Net Transactions" on google.

Hope this helps