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
How to disable cut, copy and paste in TextBox using jQuery in asp.net?
What is scope of an application variable in asp.net?
What is use of Master Page in ASP.NET web pages?
Explain how can we access static variable?
How to Insert/Add in ASPXgridview
What are validator? Name the validation controls in asp.net?
What is the Difference between MVC And MVP design pattrens
What r the asp.net list controls and difference between them?
What does uri mean?
What is the difference between adding reference in solution explorer and adding references by using ?
What is the difference between abstract class vs interface? Can give me the real time examples?
Describe how passport authentication works.
What is a web server? What are the load limits in it?
What is asp.net and its advantages?
Which Is Faster MVC or ASP.net ?