State Management

State Management is the process by which you maintain state and page information over multiple request for the same or different pages.

There are two types of state management..1) Client side
2) Server Side

Client Side : The store information on the client's computer by embedding the information into a webpage, a URL , or a Cookies ..The technique available to store the state information at the client end are listed down below..
a) View State: maintain the control state and retain the value of control.
b) Hidden field
c)Cookies: we have two types of cookies 1) persist: by default data has saved in persist cookies. and 2) NonPersist Cookies: By default data has lost in nonpersist cookies.
d) querystring: query string store value appended in the url that are visible to the user.maximum limit of query string is 255 character.

ServerSide State Management : Any data resides on the server and backand data base that's called in server side.
Two types of serverside state management: 1)Application State: Application state globaly for all user ..you can create global variable in Global.asax..inside the application.start event and session.start event.

2)Session Management : Its also globaly for a particular user...

Refresh page after 5 second

Response.AddHeader("referesh","5");

Caching in Asp.Net

Caching : Caching is a feature of Asp.Net that improves the performance of web application by minimizing the usage of server resources to a greate extent.
Caching is a feature that store data in local memory ,allowing incoming request to be served from memory directly.

Benefits of caching : Faster page rendering.
: Minimizing of database hits.
: Minimizing of the consumption of server resources.

Asp.Net support three types of caching: 1)Page level caching(output caching)
2)Page fragment caching(partial page output
caching)
3)Programmatic or data caching .

Department Wise sum() of Salary

Select * from emp order by depart desc
compute sum(salary) by depart

Aalgorithm and FlowChart

Flowchart : A flowchart is a graphical representation of an algorithm..

Algorithm : An algorithm is just a detailed sequence of simple steps that are needed to solve a problem.
A formula or set of steps for solving a particular problem to be an algorithm..

Value Type and Reference Type datatype

Value Type : All numeric data type,boolean type,char,Date,enumeration structure..

Reference Type :String,all array,class,delegate

DDL,DML in sql server

DDL(Data Defination language): DDL are used to define the database structure or schema...example...Create Table, Alter Table,Drop,Truncate,Comment,Rename..


DML(Data Manipulation Language) : Statement are used to managing data within schema object.. example....Select,Insert,Delete,Update,Merge,Lock data.