Monday, February 22, 2010

JIT Compiler and Its Type

JIT compiler is a part of the runtime execution environment.
In Microsoft .NET there are three types of JIT compilers:
111
√ Pre-JIT :- Pre-JIT compiles complete source code into native code in a single
compilation cycle. This is done at the time of deployment of the application.
√ Econo-JIT :- Econo-JIT compiles only those methods that are called at runtime.
However, these compiled methods are removed when they are not required.
√ Normal-JIT :- Normal-JIT compiles only those methods that are called at runtime.
These methods are compiled the first time they are called, and then they are stored in
cache. When the same methods are called again, the compiled code from cache is
used for execution.

SessionState modes

The available session state modes are:

InProc mode, which stores session state in memory on the Web server. This is the default.

StateServer mode, which stores session state in a separate process called the ASP.NET state service. This ensures that session state is preserved if the Web application is restarted and also makes session state available to multiple Web servers in a Web farm.

SQLServer mode stores session state in a SQL Server database. This ensures that session state is preserved if the Web application is restarted and also makes session state available to multiple Web servers in a Web farm.

Custom mode, which enables you to specify a custom storage provider.

Off mode, which disables session state.

Friday, February 5, 2010

Cursor

Cursor is a database object used to manipulate data in a set on a row-by-row basis.

Step used in Cursors are:

=> Declare cursor
=> Open cursor
=> Fetch row from the cursor
=> Process fetched row
=> Close cursor
=> Deallocate cursor

Wednesday, February 3, 2010

Add Tooltip in Drop Down List or Combo Box

Write Below code after binding the drop down list

for (int i = 0; i < ddlArea.Items.Count; i++)
{
ddlArea.Items[i].Attributes.Add("Title", ddlArea.Items[i].Text);
}