Try If con.State = ConnectionState.Closed Then con.Open() tran = con.BeginTransaction() cmd.Transaction = tran 'I need to lock database until tran commit or rollback cmd.CommandText = "select max(id)+1 from table_1;" cmd.ExecuteNonQuery() 'Do some stuff tran.Commit() ' realease database lock Catch ex As Exception MsgBox(ex.Message) tran.Rollback() ' realease database lock Finally con.Close() End Try
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)