VKinfotek Inc.
  • Us
    About Us
    Contact Us
  • FAQs
  • Ready Software
    Ready ERP ASP Core Software for Azure Cloud
    Ready Web ERP Software
    Ready ASP.Net Azure Software
    Ready C# SQL Server Accounting Software
    Ready ASP.Net MVC and EF Software
First slide
Earn $100/hour in USA! Click Here

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.



GridView Articles
  • GridView AutoGenerateColumns property
  • Bind GridView control with SqlDataSource control
  • DataBinding in a GridView control
  • Binding a GridView programmatically with dataset
  • Binding a GridView programmatically with Generic List Collection
  • Using fields with the GridView control
  • Adding Boundfields to a GridView control
  • Adding button fields to a GridView control
  • Create Templatefields in a GridView control
  • Access a value using SelectedIndexChanged() event when a row in a GridView is selected
  • How to restrict an item from being selected using GridView SelectedIndexChanging Event
  • How to add a new row in the GridView control by using the GridView footer template
  • Gridview datakeynames
  • How to select a particular row in a GridView control using SelectedDataKey method
  • Formatting GridView control with CSS
  • GridView rowDataBound event

Become an Expert

Artificial Intelligence (AI) ERP Software Development Accounting Software ERP ASP Core

Learn More

Q1. What is Azure Platform?
GridView CommandField example
GridView and DetailsView Master/Detail page using SqlDataSource control
POCO overview and advantages - POCO class, Entity Framework in Enterprise Applications
Query entity data model using linq to entities
Difference between arraylist and list collection
How to create a Web service using Visual Studio.net
FormView DataBound Event
Calling base class constructor in C#
Convert a sequence to a generic list using ToList()method
ERP Software Development
Project ideas for students
Accounting Software
Creating an ASP.Net MVC 3 application
Using assemblies in .net applications
How to implement form validation using ASP.Net 2.0 Validation Controls
Constructors in Visual Basic.Net
People also viewed: cover image of book develop erp software using asp core and deploy to Azure Create your own ERP Software using ASP Core>>


  • SITEMAP
  • Terms of use
  • Testimonials

Back to top

Copyright © 2018 - All Rights Reserved - VKInfotek.com