You need to include the Grid View Command Field column to add Edit, Update and Cancel Buttons in the Grid View. You need to include Template Field for every column you want to provide Editing because Template Field provides you both Item Template and Edit Item Template to create interface for two separate Grid View modes. You need to handle Grid View events such as Row Editing, Row Canceling Edit and Row Updating to provide desired editing functionality.Font-Names="Verdana" Font-Size="10" Data Key Names="Product ID" Auto Generate Columns="false" onrowcancelingedit="Grid View1_Row Canceling Edit" onrowediting="Grid View1_Row Editing" onrowupdating="Grid View1_Row Updating"In the above code, I set two properties Show Edit Button and Show Cancel Button of Command Field. These one relevant are defined: * rowremoved * rowsinserted * rowupdated * refresh But only refresh fires on addition of a new record into an empty grid, but it fires on any other occasion as well.
In data driven web sites, users are normally allowed to view data and administrators are allowed to add, edit or delete data.
So I'm taking a few minutes - for my own sake - to write this stuff down so I can look it up next time I have a brain fart Using a Button Field you can specify a Command Name which in turn provides the On Row Command event some context as to what type of operation you are dealing with in Code Behind.
In Code Behind you have to do a bit of work though if you want to retrieve the proper context from a Data Item.
You can further restrict when a workflow rule is triggered by specifying the type of update that triggers the workflow rule.
For example: Changes you make directly to the spreadsheet do not go through the App Sheet server, so they do not trigger the App Sheet workflow rules.