Following is an example of creating a transaction when require to save on many tables at once. I used Microsoft Enterprise Libraries. I assume one to many relation.
Dim _Connection As DbConnection = Nothing
Dim _Transaction As DbTransaction = Nothing
Try
Dim _DB As Database = DatabaseFactory.CreateDatabase("YourConnectionStringNameInConfigFile")
_Connection = _DB.CreateConnection
_Connection.Open()
_Transaction = _Connection.BeginTransaction()
//Inserting Master table record, You can set parameters here
.Insert(_DB, _Transaction)
For i As Integer = 0 To NoOfItemsInGrid
//Inserting Transaction Records, You can set parameters here
.Insert(_DB, _Transaction)
Next
_Transaction.Commit()
Catch ex As Exception
_Transaction.Rollback()
Finally
If _Connection.State = ConnectionState.Open Then
_Connection.Close()
End If
End Try