To cancel the update operation, set the collections, if necessary, before the values are passed to the data source.
A common way to use these collections is to HTML-encode the values supplied by the user before they are stored in the data source.
Step 2: We will see a Gird View control on the page, you can add, edit, delete the columns of the Grid View control, the data is come from App_Data/Grid file, and the Grid View's status is stored in View State for persisting data across postbacks.This enables you to provide an event-handling method that performs a custom routine, such as canceling the update operation, whenever this event occurs.A Grid View Update Event Args object is passed to the event-handling method, which enables you to determine the index of the current row and to indicate that the update operation should be canceled.Step 3: The Grid View the page size is 15, you need insert 16 Persons in this Grid View to see the next page. NET Empty Web Application" in Visual Studio 2010 or Visual Web Developer 2010. The project includes two web form pages for demonstrating two ways to bind data source with the Grid View, name them as "Data From Data Base.aspx", "Data In Memory.aspx". Before we start to write code, we need install Sql Server 2008 R2 Express and create a database file as the data source of Grid View control.Please click the title of the Grid View to sort the result by Person ID, Last Name or First Name properties. Add an folder "App_Data" and create a Sql Server Database,"Grid View.mdf".Step 4: Please press Ctrl F5 to show Data In page, the test steps just like Data From Data Add "Person" table with three fields "Person ID","First Name","Last Name", Person ID is the primary key of the table, and you can insert some default values in Person table. Drag and drop a Grid View control, two Link Button controls, two Text Box controls and a Panel control into Data From Data page.I was just testing if I will get the changed value out of the textbox when updating with no luck. Hi, I have grid view where i need to checck for some conditions before updating it to the database, so if the conditions fail i need to alert the user. i have a generic showalert method (attached sample from sever side) which works from a normal button, but if i use the same in the row_updating event (given below) it shows this error in the gridview "Specified method is not supported." . But I have no idea how to get those value when doing Row Editing & Row Updating. Sql Command Dim sql As String Dim reader As System.