what is page life cycle
state management
postback cross page postback
types of feilds in gridview
gridview events their life cycle
cte in sql
diff truncate and delete
paging concepts in gridview
diff bet gridview datalist and repeater
what new operations in sql 2005 compared to earlier you get

Answer Posted / minhajul islam

What is page life cycle?
Ans. When a page run it goes through a series of
processing such as initialization, instantiating controls,
restoring and maintenance of state, running events handler
and rendering.

What is state management?
Ans. When a page post on the server its lost its content
such when you enter something in textbox it will be lost
after round trip of server. To over come this issue Web Page
comes to state management. Following state management available.
1. View State
2. Control State
3. Hidden Fields.
4. Cookies
5. Query String
6. Application State
7. Session State
8. Profile Properties.

>PostBack
By default, buttons and other controls that cause a
postback on an ASP.NET Web page submit the page back to itself

> Crospage-postback
Some time we want to post one page to another page. For
Example : You might be creating multi-page form that
collects different information each page. In this case you
can configure certain controls on the page to post a
different target page.

> Types of Fields in GridView
1.Bound Field
2. Check Box Field
3. Hyperlink Field
4. Image Field
5. Button Field
6. Command Field (Select,Edit,Delete)
7. Template Field
8. Dynamic Field

>Gridview events their life cycle
1. DataBind.
2. DataBound.
3. Disposed
4. Init
5. Load
6. PageIndexChanged
7. PageIndexChanging
8. PreRender
9. RowCancelingzEdit
10. RowCommand
11. RowCreated
12. RowDataBound
13. RowDeleting
14. RowDeleted
15. RowEditing
16. RowUpdated
17. RowUpdating
18. SelectedIndexChanged
19. SelectedIndexChanging
20. Sorted
21. Sorting
22. Unload

Life Cycle is Init, Load, PreRender, Unload

>CTE in SQL
Common Table Expression, can be thought of as an
temporary result set that is defined within the execution of
scope of a single. Tis is not stored as object and last only
for the duration of query.
It can be used as
1. Creating a recursive query.
2. Substitute of a view when a general view not required.
3. Reference resulting table multiple times in the
same statement.

> Difference between truncate and delete.
truncate and delete both use to delete data from a table
but delete use may or may not use where clause while
truncate never use where clause.

> Paging concept.
Paging in a gridview used to change the page of a grid
whose data divided into page group. For example if database
returns 200 data but paging set 10 records to show in page
then there will be 20 page and we can go directly on any
page. It reduce the height of GridView

> Difference between GridView,Datalist and Repeated
1. DataGrid has paging while Datalist dont.
2. DataGrid have features Update, Insert while DataList
and repeater dont have.
3. DataList and Repeater is faster then GridView.
4. Repeater used for extensive desing of HTML while
GridView dont.

>New Operations in SQL Server 2005
1. Database Mirroring
2. Online Restore
3. Online Indexing Operation
4. Data Partitioning

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to disable cut, copy and paste in TextBox using jQuery in asp.net?

638


What is scope of an application variable in asp.net?

504


What is use of Master Page in ASP.NET web pages?

629


Explain how can we access static variable?

556


How to Insert/Add in ASPXgridview

579






What are validator? Name the validation controls in asp.net?

509


What is the Difference between MVC And MVP design pattrens

2211


What r the asp.net list controls and difference between them?

508


What does uri mean?

503


What is the difference between adding reference in solution explorer and adding references by using ?

580


What is the difference between abstract class vs interface? Can give me the real time examples?

492


Describe how passport authentication works.

578


What is a web server? What are the load limits in it?

592


What is asp.net and its advantages?

554


Which Is Faster MVC or ASP.net ?

589