How to use transctions or transaction Scope in ADO.NET

hi sankar,

yes you can acheive this using transaction scope.
for same you must enable MSDTC on SQL Server.

using (TransactionScope scope = new TransactionScope())
{
...
...
...
 // Complete is not  called and the transaction is rolled back.
        scope.Complete();
}

Please refer..
http://technet.microsoft.com/en-us/library/cc753510%28WS.10%29.aspx

http://msdn.microsoft.com/en-us/library/system.transactions.transactionscope.aspx

hope this will help you.