Rowupdating code behind

23-Sep-2017 06:43 by 2 Comments

Rowupdating code behind

I am using Template Field’s Item Template and Edit Item Template for providing read only and editing interface of the same column in the Grid View.

These properties will automatically render Edit, Update and Cancel buttons inside Grid View column.If user clicks the Cancel button while Grid View is in editing mode, you need to Cancel the Editing process and also need to reset the Edit Index property to -1 in the Row Canceling Edit event of the Grid View control as shown below: The last step is to handle the Row Updating event to actually update the back end database.To do this we first need to obtain the reference of the current row by using its index no as shown in the first line below.In the above tutorial I tried to give you one of the easiest solutions and I hope you can go explore Grid View control editing further after learning the basics from this tutorial.Save all or press "Ctrl S" and hit "F5" to run the page, the page will look as in the following image: Click on "Edit the Grid View", it will display Textboxes in each cell as in the following image: Edit the value(s) here and click on the Update link, it will update all the data or to remove it click on the "Delete" link above the image shown.You can see the C# code below will give the row number whatever you are editing by New Edit Index property.

So Grid View will put the appropriate row into the Edit Mode by assigning row number to its Edit Index property. You can follow any responses to this entry through the RSS 2.0 feed.

To avoid this we need to keep the property Read Only as false, Then in the edit mode nothing will happenes. The reason I use Template Field instead of Bound Field is that, it is very easy to grab those controls in the codebehind if we user labels or textboxes.

In case of the bound field’s we need to check what column it is and need to use index of that cloumn, which is little hard and even in future if we change the column order If you see the Last Template Field part in the above code, I am using the link buttons for edit, update, delete and cancel.

By using the Grid View Row object we can find the reference of any control in the row in which user is editing the data.

In this tutorial we are searching for our Text Box controls txt Product Name and txt Unit Price.

In the template field I will Place a label or some controls, So that it’s very easy to access those controls in the code behind by using Find Control method. Item Template is the content to display for the items in the Template Field.