vb.net - Error: Oledb transaction is completed, it is no longer available; -

this question title matches other not scenario,

here getting data form table , based on it, updating table b , inserting record in table c, make grouped these queries transaction in run time getting error, seems correct, worked on same scenario in c#.net , working fine first time trying apply in vb.net getting error appreciated

the error in following line

cmd = new oledbcommand(sql, con1, transaction)

this code unnecessary:

if con1.state con1.close() con1.open() 

your connection con1 associated transaction has closed transaction has ended.