Call custom function after every sqlConnection.Close()

[sachinkale123]

Hi I working on a application which is recording open and close connections time.

Now I want to call my custom function which will write data in to database as soon as connection is closed.

I manually can write function by finding.. sqlConnection.C lose() but
Is there any other way by which I would come to know that sqlConnction.Cl ose is called and I an invoke my method.

Thanx in advance.

[vekipeki]

Can you handle the StateChange event of your SqlConnection? StateChangeEven tArgs will then contain the new ConnectionState .