Should have on tips of our lips.........ACID PROPERTIES


Introduction

   When ever we process any DML statements transactions are implicitly called. Ie. when ever no begin  transaction statement insert ,delete, update statements will have transaction statements around them implicitly. ACID concept is one of the oldest and important properties of the Database.
It sets forward four goals that every database management system must strive to achieve: atomicity, consistency, isolation and durability. No database that fails to meet any of these four goals can be considered reliable.

Atomicity


Atomicity states that database modifications must follow an "all or nothing" rule. Each transaction is said to be "atomic." If one part of the transaction fails, the entire transaction fails. It is critical that the database management system maintain the atomic nature of transactions in spite of any DBMS, operating system or hardware failure.

Consistency

Consistency states that only valid data will be written to the database. If, for some reason, a transaction is executed that violates the database's consistency rules, the entire transaction will be rolled back and the database will be restored to a state consistent with those rules. On the other hand, if a transaction successfully executes, it will take the database from one state that is consistent with the rules to another state that is also consistent with the rules.

Isolation


Isolation requires that multiple transactions occurring at the same time not impact each other's execution. For example, if Joe issues a transaction against a database at the same time that Mary issues a different transaction, both transactions should operate on the database in an isolated manner. The database should either perform Joe's entire transaction before executing Mary's or vice-versa. This prevents Joe's transaction from reading intermediate data produced as a side effect of part of Mary's transaction that will not eventually be committed to the database. Note that the isolation property does not ensure which transaction will execute first, merely that they will not interfere with each other

Durability
Durability ensures that any transaction committed to the database will not be lost. Durability is ensured through the use of database backups and transaction logs that facilitate the restoration of committed transactions in spite of any subsequent software or hardware failures.

Hope it wil be usefull..
Regards,
Anuj Kumar

How to Add controls at run time & fetch their values

There are so many situations in which we want to add controls at run time because we do'nt know the Exact number of controls that we have to add.

These two articles show this process with Source Code.

http://www.dotnetspider.com/kb/Article2627.aspx

http://www.dotnetspider.com/kb/Article2628.aspx



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/)

A new good site

Hi,
                I want to inform about a new site on programming,database resource.This site contains  information/articles/tutorials on c# and some windows optimization tips and tricks.We have plans to expand this site to more  programming languages and database systems/tools but at this time only for c#.
               You the readers/viewers are our valuable asset,and you can contribute your articles/tutorials to this site we really appreciate any type of help from developers all over the world because you the developers helps us to make this site available and keep running smoothly...
You can visit this site by clicking url

http://www.programmerkingdom.com/

Part 2: Delete multiple records from DataGrid with the help of CheckBoxes using Stored Procedure

In last article we saw how to identify the selected rows in a datagrid and store them in a string varible. In this article we perform the Delete or Update operation on our Base Table in  two different ways.

Click here to see

Part 1: Delete multiple records from DataGrid with the help of CheckBoxes using Stored Procedure

In this article we will see that how can we delete multiple records using simply a SQL statement in aspx.cs page and then using Stored Procedure with the help of SqlParameters .
 
Click here to see
--
Thanks & Regards
Anuj Rathi
.NET Developer

Specified web server is not running ASP.NET 1.1

Hi friends,
 
    When you try to create or open Web Application in ASP.NET 1.1, you may receive the following error message:
 
" Visual Studio .NET has detected that the specified Web server is not running ASP.NET version 1.1. You will be unable to run ASP.NET Web applications or services."
 
     This is a very common error when we run ASP.NET Web Aplications. You face this problem because you have not installed ASP.NET v 1.1 & your web server is configured with it.  MIcrosoft has given a solution of this problem for IIS 6.0. You can see it at :
 
But if you are using IIS 5.1, what will you do ??? In that situation, please try this:
1. Open .NET command prompt & type
aspnet_regiis -i
  This command will install ASP.NET v1.1 & also configure your web server. When you will see the message that ASP.NET 1.1 has been successfully installed, then restart your system.
2. If after executing above command, you face that error  again then follow below procedure:
Open Internet Information Services,
-> Go to default web site
-> select properties
-> Go to Web Site Tab
 -> Go to Web Site Identification panel & select IP Address
-> Here If you have seleted your IP address like 192.168.1.100 then change it and choose "All Unassigned" from drop down. Also check the default port that is 80 by default for IIS Server.
-> Restart your system.
 
     Now your application will be run fine. For more details, please follow Microsoft web site.           
 

 

How can you convert VB.NET code to C#.NET or vice-varsa

Hello friends,
 
           I am writing something after a long time. This is a common problem of many programmers that how can they convert a large code which is written in VB.NET, to C#.NET or vice-varsa. It is really a time consuming work. Many programmers say that they was working in VB 6, so can work only with VB.NET efficiently. But I thing C#.NET is more convienent then VB.NET.
        So this is the link by which you can convert your VB.NET code to C#.NET & also C#.NET code to VB.NET.
 


--
Thanks & Regards
Anuj Rathi
.NET Developer

Windows Vista –The next generation OS

Summary:
This article explains breif description of the Windows Vista.

Introduction:
Long Horn-Windows Vista What's the difference?
I have been hearing these two terms for the name of the new OS. But these two terms are quite confusing .But actually they are one and the same.
Just like the 'Whistler 'was the Code named for XP, 'Longhorn' is the Code named for Windows Vista the latest OS by Microsoft.
In other words the alpha version of this OS is Longhorn and Beta version named Windows Vista. That means the official name for Longhorn is Windows Vista and it was named on 22nd July 2005

But LongHorn sounds great rather than Vista. Is it not?

Technologies used in developing it:
• The Windows Vista User Experience Wizard framework (For Visual Effects)
• Microsoft Windows Presentation Foundation, formerly code name "Avalon"
• Extensible Application Markup Language (XAML) technologies.


Pre-installation Environment(PE):
Windows PE2.0 (Pre-installation Environment) is a bootable tool built on Windows Vista components. Windows PE is designed to be used specifically for Windows Vista installation, troubleshooting, and recovery. Although every Windows Vista installation relies on Windows PE, we will  never be aware of Windows PE's existence unless we know about it.

It also includes Avalon" and "Indigo":

Windows Vista beta 1 also includes the first beta of Windows Presentation Foundation (formerly known by the code name "Avalon") and Windows Communication Foundation (formerly known by the code name "Indigo"), which are part of the WinFX  programming model. WinFX extends the Microsoft .NET Framework with classes for building new user interface experiences and advanced Web services. Together, they enable developers to build connected systems that take advantage of the processing power of the smart client, incorporate cutting-edge media and graphics, and communicate with other applications with improved security and reliability. IT offers Next Generation Graphics too.

Code Names

Microsoft announces code names for each and every product of themThese are some of the code names of my knowledge
ProductCodeName
Windows Workflow FoundationWinOE
Windows Presentation Foundation(WPF)Avalon(Old Name)
Windows Presentation FoundationCider (New one)
Windows Communication Foundation (WCF)Indigo
Windows XPWhistler
Windows VistaLong Horn(Old Name)
Windows VistaFusy(new one)
VS 2003Everett
VS2005Whidbey
VS2008Orcas

VS2010

Hawaii
Expression Graphics DesignerAcrylic
Expression Interactive Designer Quartz Sparkle
Expression Web DesignerQuartz

Microsoft Launch: Visual Studio 2005 Team Foundation Server


This half-day clinic will give project managers, IT leaders, architects and developers role-specific familiarity with the features of Visual Studio 2005 Team Foundation Server.

 

General Session Part 1:

Preparing the Development Team & Environment during this session, we will show you how Visual Studio Team Foundation Server helps automate the development lifecycle process and strengthen team communications. We will review the processes available with TFS and process customization. We will show how existing tools can be integrated with Team Foundation Server and how project work items can be tracked in multiple tools.

 

General Session Part 2:

Managing the Development Lifecycle during this session, we will show you how Visual Studio Team Foundation Server helps you set and enforce software quality standards and IT operations policy. We will also address advanced analysis and reporting, which provides insight into quality, performance, and reliability issues before they happen. We will also address assigning project tasks and tracking their progress through the development lifecycle.

Details

Date:   Tuesday, May 30, 2006
8:30 AM - 11:45 AM Eastern Time (US & Canada)
Event ID: 1032292768
Location: Detroit, Michigan
Language: English-United States
Recommended For:   software architects, business decision makers, developers
Product:  
Visual Studio 6.0, Visual Studio 2005 Team System, Visual Studio 2005, Visual Studio
 
For Registration Follow the link:
 
        CLICK HERE

MS Offer on Certification Hurry Up!!!!

                      Personal Pride, distinguished status, professional growth and incremental compensation are the most popular reason why IT Professionals seek Microsoft Certifications. We have just added another reason for you to get certified with the "Microsoft 2good Offer".

                    The Microsoft 2good Offer is still on and you can make the most of it by getting 20% off on your exam registration fee till the and get your chance at a second shot absolutely FREE*.
                   India is poised to be US$ 70 billion software market in 2009, providing direct employment to more than 2.2 million (and nearly twice the number by way of indirect employment).
The total number of IT and ITES professionals employed in India has grown from 284,000 in 1999-2000 to over 1 million in 2004-05, growing by over 200,000 in the last year alone.
Total IT Software and services employment to reach 1,287,000 in FY06.

In addition to the nearly 1.3 million-strong workforce employed directly in the industry, Indian IT-ITES is estimated to have helped create an additional 3 million job opportunities through indirect and induced employment.
 
 For Details Please visit:

To Access Run Commands


To AccesRun Command
Accessibility Controlsaccess.cpl
Add Hardware Wizardhdwwiz.cpl
Add/Remove Programsappwiz.cpl
Administrative Tools controladmintools
Automatic Updateswuaucpl.cpl
Bluetooth Transfer Wizardfsquirt
Calculatorcalc
Certificate Managercertmgr.msc
Character Mapcharmap
Check Disk Utilitychkdsk
Clipboard Viewerclipbrd
Command Promptcmd
Component Servicesdcomcnfg
Computer Managementcompmgmt.msc
Date and Time Propertiestimedate.cpl
DDE Sharesddeshare
Device Managerdevmgmt.msc
Direct X Control Panel(If Installed)*directx.cpl
Ditrect X TroubleShooterdxdiag
Disk CleanUp Utilitycleanmgr
Disk Defaragmentdfrg.msc
Disk Managmentdiskmgmt.msc
Disk Partition Managerdiskpart
Display Propertiescontrol desktop
Display Propertiesdesk.cpl
Display Properties(w/ Appearance Tab Pre Selected)control color
Dr. Watson System Troubleshooting Utilitydrwtsn32
Driver Verifier Utilityverifier
Event Viewereventvwr.msc
File Signature Verification Toolsigverif
FindFastfindfast.cpl
Folders Propertiescontrol folders
Fonts Controlfonts
Fonts Folderfonts
Free Cell Card Gamefreecell
Game Controllersjoy.cpl
Group Policy Editor(XP Prof.)gpedit.msc
Hearts Card Gamemshearts
Iexpress Wizardiexpress
Indexing Serviceciadv.msc
Internet Propertiesinetcpl.cpl
IP Configuration(Display Connection Configuration)ipconfig /all
IP Configuration(Display DNS Cache Contents)ipconfig /displaydns
IP Configuration(Delete DNS Cache Contents)ipconfig /flushdns
IP Configuration(Release All Connections)ipconfig /release
IP Configuration(Renew All Connections)ipconfig /renew
IP Configuration(Refreshes DHCP & Re-Registers DNS)ipconfig /registerdns
IP Configuration(Display DHCP Class ID)ipconfig /showclassid
IP Configuration(Modifies DHCP Class ID)ipconfig /setclassid
Java Control Panel(If Installed)*jpicpl32.cpl
Java Control Panel(If Installed)*javaws
Keyboard Propertiescontrol keyboard
Local Security Settingssecpol.msc
Local Users and Groupslusrmgr.msc
Logs You Out of Windowslogoff
Microsoft Chatwinchat
Mouse Propertiescontrol mouse
Mouse Propertiesmain.cpl
Network Connectioncontrol netconnections
Network Connectionncpa.cpl
Network Setup Wizardnetsetup.cpl
Notepadnotepad
NView Desktop Manager(If Installed)nvtuicpl.cpl
Object Packagerpackager
ODBC Data Source Administratorodbccp32.cpl
On Screen Keyboardosk
Opens AC3 Filter (If Installed)ac3filter.cpl
Password Proportiespasword.cpl
Performance Monitorperfmon.msc
Performance Monitorperfmon
Phone and Modem Optionstelephon.cpl
Power Configurationpowercfg.cpl
Printers and Faxescontrol printers
Printers Folderprinters
Private Character Editoreudcedit
QuickTime(If Installed)QuickTime.cpl
Regional Settingsintl.cpl
Registry Editorregedit
Registry Editorregedit32
Remote Desktopmstsc
Removable Storagentmsmgr.msc
Removable Storage Operator Requestsntmsoprg.msc
Resultant Set of Policy(XP Prof.)rsop.msc
Scanners and Camerassticpl.cpl
Scheduled Task Controlschedtasks
Sequrity Centerwscui.cpl
Servicesservices.msc
Shared Foldersfsmgmt.msc
ShutDown Windowsshutdown
Sounds and Audiommsys.cpl
System Configuration Editorsysedit
System Configuration Utilitymsconfig
System File Checker Utility(Scan Immediately)sfc /scannow
System File Checker Utility(Scan Once at Next Boot)sfc /scanonce
System File Checker Utility(Scan On Every Boot)sfc /scanboot
System File Checker Utility(Return to Default Setting)sfc /revert
System File Checker Utility(Purge File Cache)sfc /purgecache
System File Checker Utility(Set Cache Size to Size x)sfc /cachesize=x
System Propertiessysdm.cpl
Task Managertaskmgr
TelNet Clienttelnet
Te7SQL Client Configurationcliconfg
User Account Managementnusrmgr.cpl
Utility Managerutilman
Windows Firewallfirewall.cpl
Windows Magnifiermagnify
Windows Management Infrastructurewmimgmt.msc
Windows System Security Toolsyskey
Windows Update Launcheswupdmgr
Windows XP Tour Wizardtourstart
Wordpad write

Me