Get datakey value gridview rowupdating begin dating again
We can achieve the same functionality using Datakeys.
In this example, I am going to retrieve values from categories table of Northwind database. Drag a Grid View into the Web Form and assign Data Key Names property with the primary key column i.e. In the gdview_Row Editing and gdview_Row Deleting event, we have used the below code to retrieve categoryid from datakey of Grid View, int catid = int.
Database Table Structure We are using an "EMPLOYEE" table so the "EMPLOYEE" table design is: Design of Grid View We design a Grid View with which we can perform update and delete operations.
Here we can update Name, Emp_Code and Emp_Age fields depending on the Id field of the "EMPLOYEE" table.
This enables you to provide an event-handling method that performs a custom routine, such as checking the results of the update operation, whenever this event occurs.
Thus, in order to switch it into Edit Mode, in each of your event handles (Row Editing, Row Updating, and Row Canceling Edit) you must do two things: Protected Sub Grid View1_Row Editing(By Val sender As System.
Edit Index = -1 'set to no selection Bind Grid View() End Sub One issue I ran into while attempting to figure this all out was if I didn’t rebind my Grid View at the end of each event, I was required to click twice to get it to select the correct row, and if I clicked around, it would always be a row behind. This blog is for nothing else than to try and help me help you and help you help me and us help everyone else try to fix anything and everything we can’t figure out with this language.
Today was spent mostly tackling the Grid View’s Update/Edit functionality, and I got incredibly frustrated, at first. So be sure to rebind your Grid View at the end of your event handler. I’ve got a pretty good handle on it as I’ve been doing it for several years, and can help with a lot, but I definitely don’t claim to know everything.
This was my first foray into this part of the Grid View’s functionality, since I haven’t really had to develop anything using it since the switch to 2.0, as everything in Data Grids still functioned fine. The Row Updating event is where it gets tricky, since pulling values is not necessarily intuitive. That’s where you come in 🙂 If you’re interested in joining the discussion to post your own problems, fixes, etc.