Ok let’s move on to Code behind what we have to do when user clicks Edit, Delete, Update and Cancel When we click on Edit the On Row Editing event will be fired.You can see the C# code below will give the row number whatever you are editing by New Edit Index property.We have selected four columns from Employee Details table. NET Grid View Tips and Tricks series, this post shows how to cancel the Update and Delete operation in an ASP. To cancel an update and delete operation, we will make use of the Row Updating and Row Deleting events.In this article however, I'll show you how a Grid View control can be used to update (edit), delete and insert data in a remote SQL Server table. Attach the Grid View with the Sql Data Source control, the way we have shown the link above.After you have run the website, you will see the Grid View showing details of employees in tabular format.If he clicks edit (or) in the edit mode he can be able to see the Textbox.The above piece of code will also do the same as label in Item Template and Textbox in the Edit Item Template.
For demonstration I have created a database (named Database.mdf) in which we have a table named tbl_Employee.The events are as described below: Row Updating - Occurs when a row's Update button is clicked, but before the Grid View control updates the row.Row Deleting – Occurs when a row's Delete button is clicked, but before the Grid View control deletes the row.I am trying to update a row in a Gridview control whilst it is in edit mode.I am trying to extract the old data field values which have not changed during the edit process, but can't seem to find them, as the postback after clicking the edit button removes those values.Suppose if we are trying to hide primary key of our table, there is actually no need to hide. In the above Snippet you are seeing a label in Item Template that means whenever we are showing Grid View to the user Label will be visible to the user. We will use Template Field, whenever we want to define some custom control in the data bound controls like Grid View, Data Grid or Data Repeater.Secondly if you want to include a custom field (some button or link) in the same column it’s not possible.If we use proper command names for the buttons like “EDIT”, “DELETE”, “UPDATE”, “CANCEL” these will also trigger the appropriate Grid View Events.Here’s the code to cancel update and delete in a Grid View: Suprotim Agarwal, ASP.NET Architecture MVP (Microsoft Most Valuable Professional) works as an Architect Consultant and provides consultancy on how to design and develop Web applications.