Updating gridview data

Because we are not using the Grid View’s built-in data model and are binding dynamically, the Grid View will not switch into and out of Edit Mode automatically.

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.

Finally, to pull your hidden value that you’ve dubbed a Data Key in the Grid View’s subroutine.

Remember that my first column was a Hyper Link Field, so in order to pull that value, I must cast that column as a Hyper Link.

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.

With a little bit of research, a lot bit of patience, and some help from the internet community, I was able to solve all my issues, and pretty elegantly at that. You can’t do something like Dim name As Hyper Link Dim inv As Text Box name = CType(Grid View1. in an actual post, just email me or comment somewhere and we’ll talk about it.

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.

Hope this saves someone a full day of research (and possibly some hair)! To enhance this process, be sure to include your Grid View in an AJAX Update Panel. Everything should be sorted out when the “Update” link is pressed.NET page; inserting using a Sql Data Source and a Details View control; and determining the value of the just-inserted record's IDENTITY column. The , in this instance - has its value specified via the data source control's Select Parameters, which can specify a source for the parameter value.The source may be: a hard-coded value like "3.95", which would return all products less than .95; the value of a Web control on the page, allowing the user to enter a price bound in a Text Box; from the querystring; from session state; and so on.If we use proper command names for the buttons like “EDIT”, “DELETE”, “UPDATE”, “CANCEL” these will also trigger the appropriate Grid View Events.

Tags: , ,