DROP table from code

You can fire the following query using ExecuteNonQuery()

DROP TABLE myTbl;

which event??

as long as the user is n the page i need it

once th page is closed or moved to another page

i need to drop it

You can do it in Page load of another page or in Session end event in global.asax

http://www.freewebdevelopersite.com/2011/03/21/application-events-in-global-asax/