Thanks Collin , someone told me that i can use the transactionscope statement.. I think this would solve my problem. By the way, i read your sql injection article and is one of my favorites. Thanks again.

Never argue with an idiot. They drag you down to their level, then beat you with experience. - Dilbert

ok. Everything is on one machine... i'm going to try with TransactionScope then, and look for some article. Thanks for answer this Dustin, i needed the advice because i'm just starting using layers.

Never argue with an idiot. They drag you down to their level, then beat you with experience. - Dilbert

How can i manage database transactions between layers? Using Presentation, business and data layers. One solution i found is to declare transaction in the business layer then pass it as parameter to the DAL, but i think that's the worse i can do. Any ideas?

Never argue with an idiot. They drag you down to their level, then beat you with experience. - Dilbert

How can i manage database transactions between layers? Using Presentation, business and data layers. One solution i found is to declare transaction in the business layer then pass it as parameter to the DAL, but i think that's the worse i can do. Any ideas?

Never argue with an idiot. They drag you down to their level, then beat you with experience. - Dilbert

In spanish: OK = Aceptar Yes = Sí No = No Retry = Reintentar Back(Menu) = Menú Anterior Back(IE6) = Atras Cancel = Cancelar Abort = Anular Ignore = Omitir

Never argue with an idiot. They drag you down to their level, then beat you with experience. - Dilbert

Here is a good article. http://www.codeproject.com/cs/database/SqlInjectionAttacks.asp

- Never argue with an idiot. They drag you down to their level, then beat you with experience.