Asp.net Gridview Edit Update using bound Field

Hello friends


In this example, we will see how to “Edit, Update and Delete GridView Using BoundField”

In this example, I am using Employee Table

Table script:

Source Code:

C# Code:

Data():  Method will fetch records from database and bind to gridview using boundField

GridView1_RowEditing: Event Will Send the selected row in Edit Mode Using

GridView1.EditIndex=e.NewEditIndex

And Again call the data() method

Once you click on Edit Button Dynamic textbox will generate for Each Column.

GridView1_RowUpdating: Event Will get all textbox values and update that 

record in the database

           (1)              (2)       (3)

GridView1.Rows[e.RowIndex].Cells[2].Controls[0]                                                                   

(1) e.rowsIndex will give currently selected row no

(2) It will Get the  Selected Row cell number 2

(3) In that cell select 1^st control that is textbox

Like this, u will get all textbox values then just Concatenate those values In 

Update Query.

Change Some text & click on Update button

GridView1_RowCreated: Event Will fire for Each row which is going to bind

with gridview. In this Event, I’m Making EmpId column as a Read Only 

because EmpId is a 

Primary key column and while updating you need one Unique Column That’s 

why I made EmployeeId Column as Readonly(see in above image Employee Id 

is Read Only).

GridView1_RowCancelingEdit: Event will Cancel the Currently Edited Row

For canceling Current Operation just make GridView EditIndex to -1 and 

call data() method.

GridView1_RowDeleting: Event Will fire when you click on Delete button. 

Once you click on delete button it will get currently selected row and 

raise this event.

For deleting a record we need to get the EmpId id of that record.

 int Id =int.Parse(GridView1.Rows[e.RowIndex].Cells[1].Text);

Note: There are two ways of Editing and Updating Gridview rows.

In this article I explained it using BoundField In my Next Article I will show How to Edit Update GridView Using TemplateField. There are several ways for getting those dynamically generated textbox values we use that in different scenarios. If u have any queries regarding Grid View Post your comment or send mail on ranjeetpatil4545@gmail.com

Thank you