Updating gridview rows using sqldatasource
(Recall that this dialog box is accessed through the second step of the Sql Data Source wizard, by clicking the Advanced button.) As with the delete example, checking the Generate Insert, Update, and Delete Statements will create not only an UPDATE statement, but INSERT and DELETE statements as well.These can be safely removed if you are creating a Grid View that's limited to just editing the existing data. In addition to deleting a Grid View's underlying data, another common need is to allow end users to edit the data displayed in a Grid View. NET 1.x's Data Grid control, editing the data is certainly possible, but requires creating three event handlers and writing a dozen or so lines of code. NET 2.0, it is possible to create an editable Grid View without writing a single line of code!
Please review the stack trace for more information about the error and where it originated in the code. Null Reference Exception: Object reference not set to an instance of an object.
By default, the Text Boxes have no validation controls associated with them, but your business rules might require certain validation.