Now I have declared a Grid View Row variable named row and stored the current row being edited into it.With the help row variable, I am going to find all the controls placed under that row in edit mode using Find Control property.This article scope is limited to Updating and Deleting records using Grid View and I am not using any readymade Data controls for that but manually writing all event methods.I will be using Sql objects directly into methods to keep the example simple and straight forward.
In this method, I am specifying the Edit Index property of the Grid View to -1.
The example shows how you can use a Db Transaction object to add transaction context when using the Sql Data Source control to update data.
In this article, I am going to explain how to manipulate data using Grid View control.
Therefore, you cannot directly cancel the Update database operation by calling the Cancel method on the Db Command object that is exposed by the Sql Data Source Command Event Args object.
You can, however, cancel the database operation by setting the The following code example demonstrates how to display data that is retrieved from a Microsoft SQL Server database in a Drop Down List control and update the record using a Text Box control.
Now let’s start with putting the Grid View on page. Data Key Names="Auto ID" Auto Generate Edit Button="True" On Row Editing="Edit Record" On Row Canceling Edit="Cancel Record" On Row Updating="Update Record" Cell Padding="4" Header Style-Horizontal Align="left" On Row Deleting="Delete Record" Row Style-Vertical Align="Top" Fore Color="#333333" Grid Lines="None" In the above code, I have kept Auto Generate Columns as false so that Grid View will not render all the fields of the data source automatically.