help me on Web application Database transaction roll back best practices

See more:

VB

ASP.NET

SQL

I am developing a web application for accounting package. I just want to get a quick idea about best way to roll back the transaction.
My coding structure is like this

I do use the ASP.net vb coding with SQL 2012
Client side i m preparing a data set for all tables. Then pass that data set to the class file. by the from there data set getting separate to different tables.that tables row column values passing to the Stores procedure.
One after another tables going to update.
As a example -: There are two tables to update. InvoiceHeader & InvoiceLineItems
InvoiceHeader going to update first and call anothere methord to update Invoice line items.

If line items fail to update previous transaction should role back.(Invoice header)

Please give a solution onthis.

Thanks
Ashok
ashokpathirana@outlook.com