In rowupdating event in

18-Mar-2017 09:48

Row Updated = new Sql Row Updated Event Handler(da_Row Updated); Data Set ds = new Data Set(); // ... I intended to make a record update using the edit method (unsuccessfully). As I have a View Model with a proxy ajax and a CRUD api, it seems to me, after better study, is sufficient to use only (). just in case I add a new record, and I want delete this record before saving. My fiddle (It has an error, but works fine on my app) I just need to solve the issue when I add a new row with the Row Editing plugin to create a new record and, if I click cancel button, I need immediately remove the row.The HTML code for the Grid View is as follow : Till now everything looks fine but the problem arises when you run this application.When you click on edit button of the Grid View a Javascript error occurs : “Microsoft JScript runtime error: Sys. Page Request Manager Server Error Exception: The Grid View ‘gd Test’ fired event Row Editing which wasn’t handled.” At first look you may think that you have not handled some events fired by the Grid View. The mystery behind this error is the property “Command Name”.Please let me know if this has helped anyone solve the problem!!By performing above coding we would avoid the error - Specified cast is invalid.For instance, in the SQLData Source, the e parameter gives you access to the Command object being used and all of its properties. Select Command Type = Sql Data Source Command Type. If you decide to switch from SQL to Entity Framework, for instance, you won't have to change any code if you've used the Data View's events.The SQLData Source's *ing events are the best place to set values in any parameters that your SQL statements are using. Tailoring Queries In the Selecting event, additional options are available through the Select Arguments object that's available through the e parameter's Arguments property.

He has also written two EBooks 51 Recipes using j Query with ASP.

NET Architecture MVP (Microsoft Most Valuable Professional) works as an Architect Consultant and provides consultancy on how to design and develop Web applications.

Suprotim is also the founder and primary contributor to Dev Curry, Dot Net Curry and SQLServer Curry.

Using the events that are fired by the Data Sources when doing retrievals and updates gives you additional control over your application.

The Data Sources fire *ing events before doing anything (e.g. String, "SP"); In any Data Source, the e parameter's Cancel method lets you stop the Data Source from doing whatever action triggered the event.

He has also written two EBooks 51 Recipes using j Query with ASP.

NET Architecture MVP (Microsoft Most Valuable Professional) works as an Architect Consultant and provides consultancy on how to design and develop Web applications.

Suprotim is also the founder and primary contributor to Dev Curry, Dot Net Curry and SQLServer Curry.

Using the events that are fired by the Data Sources when doing retrievals and updates gives you additional control over your application.

The Data Sources fire *ing events before doing anything (e.g. String, "SP"); In any Data Source, the e parameter's Cancel method lets you stop the Data Source from doing whatever action triggered the event.

The simplest solutions for this error is : Just change the “Command Name” property of the “Edit” button from “Edit” to “Edit Row”(or something else which is relevent to you but make sure it is not “Edit”). After scratching my head for sometime I found that the words like “Edit” are reserved to invoke some built in functionality of the Grid View.