Using RollBack Transactions in VB.NET

Question

Hi..

Is there a method for using rollback transactions in VB.NET. In my application i am using 1 sql statement and 1 stored procedure first for deleting the entire table and then inserting the grid details using insert stored procedure.

My problem is when first sql statement is executed and some problem occured then the table is deleted and insertion also will not be done. So i need to use transactions in .NET , any one have solutuon please reply asap.

I am using database layer also, since it is vb
Thanks and Regards 

Sankar 
Cochin