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

Question

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]

Sanjeev Shrestha · Answer

1) If the Datareader object is put on the finally block the reader object always gets closed..no choice. If not then the connection is open .........untill the GC disposes the object......which basically means it will lock the system. 2) This is the concurrency issue in ASP.NET. Generally there is not an efficient mechanism is ASP.NET 1.1 for database concurrency issue. This will generally throw an error. 3) Session are stored in the server.............

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