ADO.NET in asp.net

Microsoft ADO.NET is the latest improvement after ADO. ADO.NET provides platform interoperability and scalable data access. In the .NET Framework, data is transmitted in the Extensible Markup Language (XML) format. Therefore, any application that can read the XML format can process data. XML (License free, fastest way to travel the data).

The ADO model uses the concept of recordsets, which are the ADO representation of tables and views from a database. Although these recordsets are very flexible to use and allow access to data even when disconnected from data sources

ADO.NET also allows you to access data when disconnected from actual data Sources. However, unlike ADO, ADO.NET uses XML as the data format. ADO.NET uses the DataSet and DataReader objects to access and manipulate data

Why Stored Procedure is beneficial in asp.net

 These are some import ants key points for making Stored     Procedure beneficial for asp.net

1. 
   
   1)    All stored Procedure creates in Database.
   2)    Created Stored Procedure will be executed in Database.
   3)    It provides the better performance as compare to Inline Query.
   4)    It is a Pre Complied File.
   5)    Stored Procedure also provides the security
   
   
   SPs are an advanced feature in SQL server that offers you to create compile and run or execute SQL statements in the server itself, improve the performance of your application.
   In short, write SQL queries in a specific format in the SQL server and call them from your application, instead of writing queries inside your program code.

IsPostBack Property in asp.net

The Page_Load ( )subroutine runs EVERY time the page is loaded. If you want to execute the code in the Page_Load( ) subroutine only the FIRST time the page is loaded, you can use the Page.IsPostBack property. If the Page.IsPostBack property is false, the page is loaded for the first time, if it is true; the page is posted back to the server (i.e. from a button click on a form)

difference between .net framework and visual studio net?

The .NET framework is the layer which is installed on an Operating system (like windows) which holds everything you need to run a .NET application. It contains the libraries which provide functionality to, for example, open files, read xml, and so on.  

The .NET framework also includes the compilers for the various .NET languages. Like 'csc.exe' (C# compiler). This gives you the opportunity to write .NET applications, compile them and run them with only the .NET framework installed.

This is where visual studio comes in. VS.NET needs the .NET framework. Whenever you install VS, the install procedure will also install the .NET framework. VS.NET makes it much easier to create applications on the .NET framework by generating source code

You could say that VS.NET is a very fancy notepad for creating .NET applications in any way, shape or form.