Some Interview Question , Plz Dammmmmm Urgent !!!!!!!!!!!

Aug 17 2006 6:08 AM
1. Using ADO.NET Datareader a user extracts data from a database table
having 1000 rows.He closed his browser in between.
that is after fetching only 50 records.
What happens to the Datareader?will it remain connected?
and will fetch 1000 records and what after?
will garbage collector collect and dispose it soon?

2. A user fetched dtata from a database table
using Dataset(Disconnected records) for updation.
Another user deleted the table just after.

what happens when the first user try to update the table after changes? Error or Something else

3.where is session id stored in ASP? in IIS aerver or ASP Engine

in wait of a quick reply.............

thanks & regards
vishal sharma
[email protected]

Answers (1)