Way To Rollback The Changes In The Server Side

i want to rollback the changes if something goes wrong either in the clients sit(internet connection failed in the time the sub is running) or in the servers side(if the server falls)is the sqltrasnsaction the properly solution??

Code:
Dim thisConnection As New SqlConnection("server=(local)SQLEXPRESS;" & _
"integrated security=sspi;database=MyDatabase")
' SQL Delete Commands
Dim sql As String = "DELETE FROM Employee " & _
"WHERE ID = 10"
' Create command
[code]...