query for recordset data into sql table

Hi,

i have a recordset on an asp page and put into session now i want to move this recordset data from session to sql server table.how can i query this.Pls suggest me...

any suggestion will be appriciable...

Thanks

Hi,

depending on your version of ASP the work to be done can differ, but here is the ASP.NET 2.0 approach, if you have the data in the session:

-Get the data from the session
-cast it to a usable data object (like datatable)
-Use a sqlcommand or datadapter to update the data on the database
(depending on your implemented database interface, DML Command Access or SP access this can differ)

HTH; Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

thanks jens for the information ...

but i am using classic ASP recordset