Server.Transfer Issue

[Ather Ali Shaikh]

I am using ADO.Net to save data in SQL Server using Transaction Object.
Method works perfectly fine when I tested that ( begin Transaction and
Commit Transaction, all are working great). But As I added Server.Transfer
(somefile.aspx) at the end of the method, every thing vanished from
database. ( as I need to transfer it to some other page on the basis of
result)
I have also tried Response.Clear() before Server.Transfer( some file ) and I
have also used Response.Buffer = True at page_load method.

Anyone, Please help...
--
Ather Ali Shaikh
Software Engineer
eIntelligence (Pvt.) Limited.
Ph. (+92-21) 2434070, 2415929-30
email. (e-mail address removed)
web. www.eintelligencesoft.com