Say for example, after a successful insertion of a new record I am going to redirect the page to success.aspx saying “A new record has been successfully added”.
Where am I going to place my redirection statement?
No, you should always have try,catch,finaly blocks. As if something goes wrong, the connection will not be closed unless it in the finaly block. If all goes well, it will get closed in the try before the redirect. And if no redirect, the finaly should check the status before it tries to close it.