MS.NET POINT: April 2016

Saturday, 30 April 2016

ASP.NET Page Structure

=> Asp.net page Structure
--------------------------------------------------------------------------------

Asp.net provide two ways for structuring the code of our ASP.net pages.
1. Inline Code Model
2. Code behind Model

Inline Code Model
---------------------------
The In-line code model is embedded directly with in the asp.net page i.e (.aspx page).
In order to build asp.net page in the inline code model instead of using the code behind model ,
Simply select the "Web form" template from the "add new item " templates window

and make sure that the "Place Code in Separate file " check box option is not selected.

And finally click on Add button to create an asp.net page that uses inline code model.
Once we click add button, an asp.net page will be created with a single file like Default.aspx. And by default this page opened in the source view if the following markup tags structure :-

Note : For the inline code model of an asp.net page ,all business code must be embedded in .aspx page only in the given section i.e <Script runat ="Server">
because in line code model not supported a separate file for business code of the page.

Code Behind Model
-----------------------------------------------------
The code behind model is more preferable model rather than In line code model. And this model provides a separation of user interface and code that allows user to develop and maintains more easily as well as simultaneously users can work on the page as well as on the code.

Once we click add button, an asp.net page will be created with a two file like Default.aspx and Default.aspx.cs. And by default this page opened in the source view if the following markup tags structure :-
+

These are the following options for few Items in an asp.net web development environment that uses code behind model.

1. Web Form
----------------
.aspx file and .aspx.cs or .aspx.vb file
2. Master page
------------------
.master file and .master.cs or .master.vb file
3. Web User Control
-------------------------
.ascx file and .ascx.cs or .ascx.vb file
4. Web service:-
--------------------
.asmx file and .asmx.cs or .asmx.vb file

IIS (Internet Information Service)

=> What is IIS (Internet Information Services) ?

IIS stands for Internet Information Service. IIS is a Microsoft enterprise level web server software product. It has initially support for Classic ASP and as well as ASP.net.

=> How to install IIS (Internet Information Services)

Step 1 : First go to the control panel .

Step 2 : Then Click on Program and Feature

Step 3: Left hand side click on Windows features On or Off.

step 4 : Then open a dialog box Click on Internet Information Services and check all the sub check box of internet information services.

step 5 : After that finally type the browser url
http://localhost and press enter key. to check the iis install or not.

finally you get on the browser screen

=> How to Open IIS Manager.

There are 3 ways to open IIS manager

1st Ways
----------

Go to Start -> Run -> type "inetmgr" and press enter button.

Open IIS Manager on the screen

2nd ways
-----------

Right Click on

My computer

click on ' Manage'

Open Computer Management

Expand Services and application and then click on Internet Information Services

3rd ways
-----------

Control panel ->

Administrative tools and select internet Information Servicers

by default port no : 8080

What is ASP.Net ?

=> What is Asp.net ?
-----------------------------------------------------------

According to MS "ASP.net" is web technology for building powerful,Dynamic web application and it is part of .net framework.
In other words we can say ASP.net is a programming framework used to developed web application and web services with the help of any compatible .net technologies.

=> Web Application Flow.
-----------------------------------------------------------

step 1: Initial request is triggered by user through the browser over the network to the web server.

step 2: The web server manage the request forwarding to the application web application server.

step 3: The web application server perform the request task.

step 4: Access the database ,if needed. And response back to the web server.

step 5: The web server response back to the user with the successful transaction.

step 6: And finally output appears on the user browser.

=> Benefits of web based application.
-------------------------------------------------------------
Their are several benefits of web based application. These are as follows.
1. Cost effective development.
2. Accessible any where.
3. Security
4. Flexible core technology.
5. More Useful for user.

=> Type of Web Application.
--------------------------------------------------------------------
1. Presentation oriented web application.
2. Service oriented web application.

=>Features of ASP.Net
-----------------------------------------------------------------------

There are several features of ASP.net. These are as follows:-

1. Easy/Simple programming model.
2. Flexible language option.
3. Complete Object oriented model.
4. Separation of code and UI (User Interface).
5. Great tool support.
6. Security
7. Maintain page state.
8. Session State
9. Mobile Web device support.

DBMS Basic Concept

=> DBMS Features

------------------------------------------------------------------------

(1) . Redundancy

(2) . Security

a. Authentication

b. Authorization

(3) . Data integrity

(4) . Atomicity

=> RDBMS Features

--------------------------------------------------------------------------

1. Large amount of data can be store.

2. Structure Query language

a. DDL ( Data Definition Language)

b. DML (Data Manipulation Language)

c. DCL (Data Control Language)

d. TCL (Transaction Control Language)

e. DQL (Data Query Language)

3. multiple table can be joined.

4. Multiple relation can be created between tables relation can be

1:1 (One to one)

1:M ( One to many)

M:1 (Many to One)

M:N (It is combination of Many to one and one to many)

=> Data Models

---------------------------------------------------------------------------------

Their are several type of data model.

1. physical Data Model

2.Conceptual Data Model

3. Logical Data Model

a. Hierarchical data model

b. Network data model

c. Relational data model

d. Object data model

e. Object relational data model

=> Constraints
------------------------------------------------------------------------------------
Constraints are used to give conditions or rules on the table so that valid and meaningful data cab be store in table.

type of constraints
----------------------------------------------------
1. Unique
2. Not null
3. Primary key
a. Candidate Key
b. Secondary Key (Alternate Key)
4. Foreign key
5. Composite key

=> Normalization
----------------------------------------------------------------------------------------
Normalization means decomposing of larger and complex data into simple and smaller tables.

Advantage of normalization
--------------------------
a). Redundancy can be reduce
b). Inconsistency can be avoided.
c). Related data will be stored in table.

Their are several type of normalization.
1. First Normal Form (1st NF)
2. Second Normal Form (2nd NF)
3. Third Normal Form (3rd NF)
4. Boyce Code Normal Form (BCNF)
5. Forth Normal Form (4th NF)

=> De normalization
----------------------------------------------------------------------------------------
De normalization means it is a reverse of normalization it contains data redundancy or data repetition.

=> Database means collection of tables.
=>SQL Server contains two types of database
1) OLTP (Online Transaction Processing).
2) OLAP (Online Analytical Processing).

Architecture of Asp.net

INTRODUCTION OF ASP.NET

We can say that ASP.net is programming framework used to developed web applications and web services with help of any compatible .net language. Such as visual C#.net or Vb.net.Basically it is next generation of Classic ASP.

It provides the easy way to build, deploy and run web application on any browser.

In another words we can say that Asp.net is a web development platform, which provides a program model, a comprehensive software infrastructure and various services required to build up robust web application for personal computer as well as mobile application.

What is Web Application

A web application is an application program i.e. stored on a remote server and delivered over the internet or intranet through a browser interface.

In another words we can say that A web application is s/w package that can be accessed through the web browser interface. The s/w and database reside on a central server machine interface. Rather than being installed on the desktop machine and it is accessed over a network.

Flow of web Application

1. Initial request is triggered by user through the browser over the network to the web server.

2. The web server manage the request forwarding to the application web application server.

3. The web application server perform the requested task.

4. Access the database ,if needed.

5. And response back to the web server.

6. The web server response back to the user with the successful transaction.

7. And finally output appears on the user browser.

Interview Question

1. What is synchronous program?

2. What is Service Oriented Architecture (SOA)?

3. Difference between ASP and Asp.net?

4. What is difference between ADO and ADO.net?

5. What is Page Life cycle in ASP.net?

6. What is Page Life Cycle Events? Take any two Events and describe it?

7. What is rendering? & what are the uses of rendering?

8. Difference between Response.Redirect and Server.Transfer?

9. What is session and why we use it?

10. What is state Management?

11. What is join?

12. Difference between Stored & function?

13. What is trigger?

14. What is index?

15. What is Dataset?

16. What is Datatable?

17. What is difference between Dataset And Datatable?

18. What is difference between string & string builder?

19. What is interface?

20. What is Abstract method & abstract class?

21. What is Data Adapter?

22. Write the connection?

23. Difference between Execute Scalar & Execute Reader?

24. How to follow the flow of data in 3 tire architecture?

25. Why we use the view state?

26. What is Authorization & Authentication?

27. What is namespace?

28. Why we use the web.config?

29. How many property of grid view?

30. In which property we use for change the row color in grid view?

31. What is Datagridiew?

32. What is Boxing & Un-Boxing?

33. What is reference type & value type?

34. What is post back & cross post back?
35. What is Primary key and Foreign key ?
36. What is State Management and why we use it ?
37. I have 3 table
(i) tbl_country (id (pk),cname)
(ii) tbl_state (sid (pk),sname,id(fk))
(iii) tbl_district (did (pk),dname,population, sid(fk))
query 1. write the query to show county name, state name, district name.
query 2. write the query to show country name and its population.
38. Can we create the object of static class ?
39. What is interface and why we use interface ?
40. In which cases we use the interface ?
41. why we use the abstract methods and abstract c class?
42. Can we create the object of abstract class ?
43. What is tracing in Asp.net?
44. What is the difference between out and ref in c#?
45. What is Application state in Asp.net ?
45. What is the difference in Session state and Application state ?
46. What is selector in jquery ?
47. What is DOM in jquery ?
48. What is Serialization and De-Serialization ?
49. What is Reflection ?
50. Where is store the application state in Asp.Net ?

MS.NET POINT

Page

App Install