SQL Transactions RollBack...

Hello:





I am just starting to falmiliarize myself with SQL transactions... I just created an SQL transaction... The first statement gets a value, if the value equals "" then the second statement executes... So if the value <> "" Then the second statement wont execute... What would happen in this scenario if the .Rollback is triggered? Heres my code:





Try


conSqlConnect.Open()


objTransaction = conSqlConnect.BeginTransaction


cmdSelect.Transaction = objTransaction


cmdInsert.Transaction = objTransaction


dtrdatareader = cmdSelect.ExecuteReader()


While dtrdatareader.Read()


varCheckNumber1 = dtrdatareader("Status")


End While


dtrdatareader.Close()


If varCheckNumber1 = "" Then


cmdInsert.ExecuteNonQuery()


End If


objTransaction.Commit


Catch


objTransaction.RollBack


Return "00"


Finally


If conSQLConnect.State = ConnectionState.Open Then


conSqlConnect.Close()


End If


End Try








Any Ideas?