ADO.NET and its Features

ADO.NET is a technology used for working with data and databases of all types .It provides access to data sources such as Microsoft SQL Server, data sources exposed through OLE DB, and eXtensible Markup language (XML). We can use ADO.NET to connect to data sources for retrieving, manipulating, and updating data.
Some features of ADO.NET are as follows:

• Disconnected Data Architecture- Implies that application connected to the database only when data needs to be retrieved or modified. After the database operation has been performed, the connection to the database is closed.To perform any database operation again, the connection with the database will have to re-established.
• Cached Data in Datasets- follows a disconnected architecture for accessing or modifying data.it is not required for the application to connect to the database for processing each record. Therefore, the data is accessed and later stored in the datasets. A dataset is a cached set of database records, which is independent of data source.
• Scalability- Reduces the traffic on database and save the resources to make the database more efficient in meeting the demands of the user. ADO.NET helps in attaining scalability while working with datasets.
• Transfer Of Data In XML Format- Transfers data from a database into a dataset and from the dataset to another component using XML, which is the standard format used for transferring data in ADO.NET.
• Interaction with the Database through Data Commands- Specifies that database operations are performed by  executing the data commands. All operations on database, such as retrieving, modifying, or updating of data are performed using data commands.

AJAX and its ADVANTAGES

 In the 1990s, most web sites were based on complete HTML pages; each user action required that the page be re-loaded from the server (or a new page loaded). This process is inefficient, as reflected by the user experience: all page content disappears then reappears, etc. Each time a page is reloaded due to a partial change, all of the content must be re-sent instead of only the changed information. This can place additional load on the server and use excessive bandwidth.


Asynchronous JavaScript and XML(AJAX), formerly code-named as ATLAS, is an extension of ASP.NET for developing and implementing the AJAX functionality. ASP.NET AJAX includes both  client side and server side components that allow the developers to create Web application that are capable to update the data on a website without a complete reload of the page


Following are the advantages of using AJAX :

• Asynchronous- Enables asynchronous calls to the Web server without making the users wait for the data.
• Minimal transfer of data- Helps in sending only a part of the modified data to the Web server to minimize the network traffic and perform the operations quicker.
• Minimal processing on the web server- Minimizes the processing on the Web sever as only the necessary data needs to be sent. Now, the server is not required to send a full page to the user.
• Context- Reduces burden on the server by sending a request back to the server through the client-side script. AJAX-based application implement partial page post backs instead of full page post backs, which reduce the data traffic between the client and server. 

Windows Forms in .NET

Windows Forms is the graphical representation of any window displayed in an application . It is included as a part of Microsoft's .NET Framework. We can create an application using Windows Forms in any CLR supported language. A Window Form is used to either accept input form or display information to the user. In Windows Forms, we add controls to the forms and raise events, such as mouse-click, which is handled by event handlers in an application.