Key points of Grid View Control in asp.net

1. Here we can manipulate the data as like a data list control(Insertion, deletion)
2. Here we can get the data at runtime in tabular form automatically. 
3. Here we can easily sort the data in ascending or descending order through the sorting property in Grid view.
4.  In the Grid view control, we get the default template
5. Auto edit, Auto delete, Auto Select options are preoccupied here

         In the grid view control, we can apply eight templates

1.     Item template

2.     Edit item template

3.     Alternating Item template

4.     Header template

5.     Footer template

6.     Selected Item template

7.     Pager template

8.     Empty Data template

Data Repeater control in asp.net

1)    It is used to display data in single column.

2)    No Manipulation is allowed in data repeater.

3)    There are no Paging concept in data repeater

4)    There are no default templates.

Here we have Five Templates are applied on data repeater

1)    Item Template

2)    Alternating Item Template

3)    Header Template

4)    Footer Template

5)    Separator Template

Disconnected approach for binding the data in data bound control

public partial class Default2 : System.Web.UI.Page

{

    protected void Page_Load(object sender, EventArgs e)

    {

        if (Page.IsPostBack == false)

        {

            rep_bind();

        }

    }

    private void rep_bind()

    {

        SqlDataAdapter adp = new SqlDataAdapter("Select * from tbbook1", ConfigurationManager.ConnectionStrings["cn"].ConnectionString);

        DataSet ds = new DataSet();

        adp.Fill(ds);

        Repeater1.DataSource = ds;

        Repeater1.DataBind();

    }

}

Composite Data Bound control and types in asp.net

            Composite Data-bound controls are controls that can be bound to a data source control to make it easy to display and modify data in your Web application.There are total 8 data bound controls presents in asp.net 4.0 version, 

           Data Bound Control in Framework 2.0 Version

   

                                 1)    Repeater

                        2)    Data list

                        3)    Grid view

                        4)    Detail view

                                 5)  Form view

            Data Bound Control in Framework 3.5 Version.

          Here we added some more Composite Data Bound Control

                       1)    List view

                       2)    Data view


   Data Bound Control in Framework 4.0 Version.

                   1)    Chart control

   Note : - Text boxes and labels are also data bound controls, but it binds less amount of data.

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.