DROP table from code

svibuk

i create a sql table on page load

table name is generated randomly using session varaible

when the page is no longer in use or closed

i need to remove all the session variables aswell as drop the tables created in SQL from code

Mudassar

0 1

You can fire the following query using ExecuteNonQuery()

DROP TABLE myTbl;

svibuk

0 2

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

Mudassar

0 3

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

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html