What is a GridView ?

The GridView control is a feature rich and versatile control used to accept, display, and edit data on a web page. It is a commonly used control in ASP.Net web applications.

To use a GridView control a DataSource control has to be attached to the GridView control. The property DataSourceID of the GridView control binds the GridView control to the DataSource control and allows paging, sorting and database operations with the DataSource.

There are four popular DataSource controls and SqlDataSource control is one of them. We use SqlDataSource control, to attach the GridView control to the Sql Server Data base.

The SqlDataSource control contains ConnectionString, SelectCommand, UpdateCommand and DeleteCommand properties. The ConnectionString property connects the DataSource (SqlDataSource) control to the database and properties such as SelectCommand, InsertCommand, UpdateCommand, DeleteCommand contains SQL statements that are executed when we display, insert and delete records using the GridView control.
working of gridview control with SqlDataSource control and the Sql server database

A GridView control and a SqlDataSource control is placed on the web form. The Select, Delete, Insert and Update commands are used to interact with the Sql Server database.

The Figure shown above gives a overview of how the gridView control works in tandem with SqlDataSource control and the Sql server database. The GridView control is placed on the web form and is visible to the user. The SqlDataSource control is placed on the web form and is not visible to the user at runtime.

After the DataSourceID of the GridView control is set, the SqlDataSource control is ready to establish a connection with the Sql Server database, retrieve data from the database table and pass the data to the GridView control.

For inserting records, either the DetailsView or the FormView control is commonly used with the GridView control. However, we can also use GridView controls FooterTemplate to insert records.

While developing commercial database software such as Accounting or ERP software, we can use GridView controls FooterTemplate to insert records. We need not use DetailsView control or the FormView control.

GridView control supports programmatic access to the GridView object model and sets properties and handles events dynamically.

The GridView control is the successor to the DataGrid control. The GridView control displays database records in a HTML table with each record in a table row and each field in a column.
data displayed in a gridview control with edit and delete buttons

To display data in the GridView control from the sql server database, we need to bind the GridView control to the SqlDataSource control either declaratively or programmatically.

By default, the AutoGenerateColumns property is set to 'true', which renders each field in the data source as a column in the GridView control.

We can also define seven field types to create columns in the GridView control.

cover image of azure cloud book

Develop Azure Applications

Azure Cloud is gaining popularity and is competing with Amazon Elastic Cloud and Google Cloud for a spot in the billion dollar Cloud computing space.

With this book learn how to use - Table (an Azure Table is different from a SQL Server Table), Queue, Blob storage services, use your local machine to create an Application and a Service, how Azure splits a Table to achieve Load Balancing, Scalability based on the Partition Key, AppFabric Service Bus, Access Control Service, role of Fabric Controller, features of Azure SQL Database and Content Delivery Network.

Many have mastered Cloud Programming and are enjoying the benefits. Why not you?

View Highlights » View Contents »
cover image of foundation database programming book

Create your Own Accounting Software

A foundation book to Master Accounting Software Development, VB.Net, C# and OOPs programming. Detailed explanation of the Accounting domain for programmers is included. SQL and ADO.Net is also covered in detail.

This book gives you a strong foundation in Application Development.

A thorough understanding of the contents will enable you to grasp the topics covered in the accompanying books quite easily. This is because, the accounting domain is dealt with great detail in this book.

The ideal book to get started with application development in the .Net world.

View Highlights » View Contents »

cover image of asp.net book

Create your Own WEB ERP Software using ASP.Net

This book opens you to the Web. Using ASP.Net, C# and SQL Server as the tools, you will learn to build a Multi Tier Web Application as recommended by Microsoft. You will learn implementing inline GridView control, Transaction Management for a layered Web Application, build Data Access component and a Business Layer component.

Opens you to a world of opportunities. You will be able to develop a Web ERP application including all the five modules and learn how to use the TreeView control and GridView control to implement transactions such as Purchase Invoice, Sales Order and Sales Invoice.

View Highlights »
cover image of entity framework book

ASP.Net MVC 5 Application Development Using Entity Framework 6 and VS 2015

Entity frameworks is the latest buzz in .Net programming and is the data access technology for Microsoft OS based hand held devices and web applications. Learn to integrate EF into an ASP.Net Application and MVC application. Create, explore and query the Entity Data Model. Learn how to use ObjectDataSource control and GridView control in an ASP.Net Application.

Also, learn to build Three-Tier ASP.Net application, create a business-class, implement methods in the class to perform CRUD operations and bind a GridView to the ObjectDataSource control. Learn how to handle concurrency and managing Transactions.

View Contents »