Dear All,
I have developed a VB.net application, where i have created a data acess componenent through whihc i am creating the connection. To open this connection i am paasing the connection string values through a module. This is working fine in my application.
1>My Problem, as the connection is opened through a companent, i can not use the same connection object any where else in the application to write connection.Begintransaction . I think my architecture and idea of using component for connection is wrong. I am confused and tensed as i cant use transaction object any where.
2>Right now the connection is remaining open till the application is running, and no where(not in any form explicitly) i am closing the connection. I did this by thinking the dataset is a connectionless, it will take care. Dont know whether i am doing rite thing or not. Shall i open the connection on each form load and close it on form close , irrespective of the connection open globally which i have opened on application load.
Please help,
Thanks in adavance.
Lokanath Subudhi
9440388696
