A very good article to wite stored procedures

Hi friends,

I have found a very nice article to write the Stored Procedures in Sql Server. Its really good & explain step by step.
Just try it.
http://www.sql-server-performance.com/tn_stored_procedures.asp

The Thing that happens behind the Screens!!

Introduction


Many of us know that IIS is a web server and we use it in our .Net application since we need a web server to run a web application. But I wonder as many of us don't know the internal architecture of IIS. This article is written for beginners to  know the architecture of IIS.

How the Simple Web page execution Happens?

As All of us know A Request comes from Client (Browser) and sends to Server (We call it as Web server) in turn   Server Process the Request and sends response Back to the Client in according to the client Request

But internally in the Web server there is quite interesting process that happens. To get aware of that process we should first of all know about the architecture of the IIS


It mainly consists of 3 Parts/Files

1. Inetinfo.exec

2. ISAPI Filer (Container for Internet Server Application Interface dlls) ,

3. Worker Process (aspnet_wp.exe)

When ever a Request comes from the Client:


Inetinfo.exe is the ASP.Net Request Handler that handles the requests from the client .If it's for static resources like HTML files or image files inetinfo.exe process the request and sent to client If the request is with extension aspx/asp inetinfo.exe processes the request to API filter. ISAPI filter will have several runtime modules called as ISAPI extensions. To process the request ISAPI filter takes the help of these runtime modules .The runtime module loaded for asp page is asp.dll. And for asp.net page it's ASPNET_ISAPI.dll. From here the request is processed o the Worker Process. Worker Process will have several Application Domains


Application Domain


The purpose of the Application Domain is in order to isolate one application from another. When ever we create a new application, application Domains are created automatically by the CLRHost. Worker process will create a block of memory related to particular application. Application domains provide a more secure and versatile unit of processing that the common language runtime can use to provide isolation between applications. Application domains are normally created by runtime hosts. Runtime host is responsible for bootstrapping the common language runtime before an application is run.



Worker process sends the request to HTTPPIPE line.(HTTP Pipeline is nonetheless collection of .net framework classes). HTTP Pipeline compiles the request into a library and -makes a call to HTTP runtime and Runtime creates an instance of page class



public class File : System.Web.UI.Page

             {

             

            }

ASP.Net web page is a class derived from Page class ,this page class resides in system.web.dll


After creating instance pf Page class HTTP Runtime immediately   invokes Process Request Method of Page class

           Page Req = new Page();

          Req.ProcessRequest();



Process Request Method Does Following things

1.Intialize the Memory

2.Load the View State

3.Page Execution and Post back Events

4.Rendering HTML Content

5.Releasing the memory


Process Request Method executes set of events for page class .These are calles as Page life cycle events.

Page Life Cycle Events


Page_Init
The server controls are loaded and initialized from the Web form's view state. This is the first step in a Web form's life cycle.

Page_Load
The server controls are loaded in the Page object. View state information is available at this point, so this is where you put code to change control settings or display text on the page.

Page_PreRender
The application is about to render the Page object.

Page_Unload
The page is unloaded from memory.

Page_Disposed
The Page object is released from memory. This is the last event in the life of a Page object.

Page_Error
An unhandled exception occurs.

Page_AbortTransaction
A transaction is aborted.

Page_CommitTransaction
A transaction is accepted.

Page_DataBinding
A server control on the page binds to a data source.  

Process Request Method finally renders HTML Page

Dependencies:



When the request comes to ASP.net worker Process, it will be forwarded to HTTP Application factory.  This Application Factory will maintain address of the Application Domains which are currently executing under worker process. If the required virtual directory application domain is unavailable it will create a new Application Domain. If the application domain is already existent, the request will be forwarded to Corresponding AppDomain.

Application Domain maintains Page handler factory class. This will contain all libraries addresses corresponding to webpage. If the requested webpage library is available the instance of the page class is created, if the library is unavailable the request will be forwarded to http pipeline.


Note:

In ASP 2.0 we don't need to install IIS in Your system. It comes with Built in ASP server

New group for the .net developers


Hi, friends I have started a new group, mainly for those who lives in Delhi/NCR & connected to ITBS.
You can visit this group at CLICK HERE
(If above does't work then copy & paste the link http://groups.yahoo.com/group/itbs_dotnet/)