"FRONT OFFICE AUTOMATION SYSTEMCn. Open ();Sql Command;Command Type;Command<object> <method ()>;ExecuteNonQuery:-It is a method in Ado .Net used to perform Non-Query action.Example: insert, delete, update.ExecuteScaler:-It is a method in Ado .Net used to retrieve a single entity from the back end.Example: “select user id from EMP where ename = swathi”;ExecuteReader:- It is a method in Ado .Net used to retrieve the data from back End.Example: Select *from EMP ExecuteXmlReader:-It is a method in Ado .Net used to retrieve the xml data in the. Net applications. ASSEMBLY: Logical collection of one or more .exe and .dll files is called as Assembly and thecompile source code of. Net architecture. There are two types of assemblies:? Single assemblies, and? Multi file assemblies.DEPT OF IT, PDCE 2009-2010 Page 10 FRONT OFFICE AUTOMATION SYSTEM.EXE:- Self execution files and not reusable..DLL:- Not self execution files and reusable.Assemblies of single file Content:1. Manifest- metadata of assembly2. Type metadata-data about assembly class3. Msil-microsoft integrated language 4. Resource- external resource.Microsoft integrated language is divided into four parts according to theversions:-? Version 6.0 major? Version 3.0 minor? Version 0.0 build? Version 1.0 revisionAssemblies of multi file Content:1. Manifest- metadata of assembly2. Type metadata-data about assembly class3. Msil-microsoft integrated language These are myassembly.dll1. Metadata 2. Msil-microsoft integrated language Before Microsoft intermediate language (MSIL) be executed, it must be convertedby a .NET Framework just-in-time (JIT) compiler to native code, which is CPU-specificcode that runs on the same computer architecture as the JIT compiler. DEPT OF IT, PDCE 2009-2010 Page 11 FRONT OFFICE AUTOMATION SYSTEMRather than using time and memory to convert all the MSIL in a portable executable(PE) file to native code, it converts the MSIL as it is needed during execution and storesthe resulting native code so that it is accessible for subsequent calls. The runtime supplies another mode of compilation called install-time codegeneration. The install-time code generation mode converts MSIL to native code just as theregular JIT compiler does, but it converts larger units of code at a time, storing theresulting native code for use when the assembly is subsequently loaded and executed.As part of compiling MSIL to native code, code must pass a verification processunless an administrator has established a security policy that allows code to bypassverification. Verification examines MSIL and metadata to find out whether the code can bedetermined to be type safe, which means that it is known to access only the memorylocations it is authorized to access. VALIDATION CONTROLS AND PAGE NAVIGATION:Validation controls:Validation is the process of making sure that the user enters correct information intoa form. Validation controls is provide by the .Net framework in the client browser, if thebrowser supports Java script and DHTML and checks the data that user entered beforesending it to the server. The entire validation take place in the browser and nothing is sentback to the server. If the browser does not support DHTML and scripting then it is done onthe server. All validation controls in theNet frameworks are derived from theBaseValidator class.The validation controls that are provided by the. Net frameworks are as following:1. Required Field Validator2. Compare Validator3. Range ValidatorDEPT OF IT, PDCE 2009-2010 Page 12 "