try catch block execution

Question

hi everyone

my doubt is that
iam writing some code with in a try catch block which is connecting to database  and bringing data.

intailly connection is opened and execution is started
at a sudden it looses the connection to databse because of some  LAN Probelm.
when exception raises and catching that in the catch block.
 In Catch block iam checking connection  state, if it is closed iam again trying to connect to database.i will try till it is connected to database.

my issue is that when iam connected to database in the catch block i should start execute from the same procedure where i was lose my connection. or the line where i lose the connection.


warm regards