Server.Transfer is used when redirecting the webpage with in the same applicationwhereasResponse.Redirect is applicabletowards the redirection of webpage between 2 applications
Response.Redirect will instruct browser to call a particular webpage.This will increase one request and one response between the client and server.
Also browser will not keep the visted pages in history when we use Server.Transfer Clicking n back button in browser will take us to 2 steps back.
How to create a DB connection at one place/page so that we can use that connection for all pages/forms/windows.what r the steps ned to be performed. if question not clear,let me know.