Here we can update Name, Emp_Code and Emp_Age fields depending on the Id field of the "EMPLOYEE" table.

Create SQL Connection We need a connection with a Microsoft SQL Server database so we can access data and perform an operation on it.

The Grid View control is a tabular databound control but sometimes it is used like a spreadsheet control. NET 2.0 and is an improved version of the Data Grid control. We can use this to display data from a database and edit, sort and select the data.

Database Table Structure We are using an "EMPLOYEE" table so the "EMPLOYEE" table design is: Design of Grid View We design a Grid View with which we can perform update and delete operations.

Before going to start we have to set the grid view properties i:e(Autogenerate Delete Button, Autogenerate Edit Button, Autogenerate Update Button) to enable the auto generate Edit, Delete, Update buttons.

Net Grid View control with simple Data Set or Data Table, and also explains the methods like Insert, Edit, Update and Delete function in the Grid View control.

You can not attach validation controls directly to these Text Boxes.

In this article we will look at how to update or delete a record in a database table using a Grid View control.

So how do you have the Grid View update the database under these conditions?

Here, we set the Data Source of the Grid View to Sql Data Source1. We also enable paging, sorting and editing features of the Grid View.

By default when the Grid View controls goes in edit mode, it displays Text Boxes for entering values.

We define a connection in the web.config file and give a name to the connection string.

Now we access this connection string on the page so we can open a connection with the relation database. The first one accesses the connection string and the other is for the SQL connection.