Binding a Grid View control can sometimes get tricky when using the Visual Studio editor, especially when working with Drop Down List controls within the grid. Today I was working on getting a row of the Grid View control to save the contents of a Drop Down List, and needed to add some custom code to set values passed to the Sql Data Source control on the update event. In practical scenario you should use your existing architecture to populate and update the data.In this article, I am going to take a simple database table that has following fields: Auto ID - Int, Auto Increment, Primary Key Page Name - Varchar(50) Page Description - Varchar(500) Active - Bit(1) In this article, I am not going to explain the workings of Sql objects but focusing on the events and methods of the Grid View that will help us in updating and deleting the records. Yes, I did put the breakpoint at the Row Updating line (and not in the function).You have to make sure that you aren't setting your Grid View's data when it is not postback.
In this article, I am going to explain how to manipulate data using Grid View control.I found that simple data binding of my Drop Down List in my Grid View to my Sql Data Source was not going to be enough. I would need to set values passed to the Sql Data Source control on the update event, and as part of this I would need to reference the controls contained in the row being updated. If you do this, your Grid View's source will be refreshed before you're able to grab the new values out of it.I'm having a very hard time understand what would prevent your event from being fired.To do this, I created an instance of the Row Updating event for the Grid View. This event passes the necessary information to the method via the Grid View Update Event Args parameter. Find Control("Label20e"), Label) Sql DSupport Info. 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.Then within the new method one can access controls within the Grid View row being edited by referencing the Row Index attribute of the Grid View’s Rows collection. Find Control("ddl Service Level List"), Drop Down List) Dim lbl Support Date As Label = CType(GVSupport Info. So for example to reference a Drop Down List within the Grid View Row, use the syntax: Basically this is quite straightforward once one knows the syntax for referencing a control within a Grid View Row. Grid View Update Event Args) Dim lbl Service Level As Drop Down List = CType(GVSupport Info.