Gridview updating event in asp net
I will be using Sql objects directly into methods to keep the example simple and straight forward.
In practical scenario you should use your existing architecture to populate and update the data.
Currently in the grid I have the below UI: 1) Initially I want 5 rows to be in Insert mode. 2) In the Button click, how to retrieve the values?
3) when user clicks "Add New Item" button, i want to create a only one row in which user can insert data.
To get the Primary key, I have used Data Keys property of the Grid View with the index of the row, being edited and stored into a integer variable after parsing.
Now I have declared a Grid View Row variable named row and stored the current row being edited into it.
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.
In this article, I am going to explain how to manipulate data using Grid View control.
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.
Handle the ASPx Grid View Row Inserting/Row Updating/Row Deleting events if you want to submit a batch of modifications individually via a corresponding CRUD procedure. Batch Update event if you want to submit a batch of modifications at once via a corresponding Batch Update procedure.
Note that this example uses a custom local data source stored in Session.You can notice that I have kept Required Field Validator too inside the Edit Item Template as I want the textbox to be validated for empty data.