asp.net core docker Keep gridview in edit mode when update fails due to data conflict - Part 20

Link for csharp, asp.net, ado.net, dotnet basics and sql server video tutorial playlists
http://www.youtube.com/user/kudvenkat...

Link for text version of this video
http://csharp-video-tutorials.blogspo...

In this video, we will discuss about
1. Diplaying appropriate status messages depending on the success of update.
2. If the update fails, leave the row in "Edit" mode.

Please watch Part 19 of asp.net gridview tutorial before proceeding.

If there are no concurrency conflicts and if the update succeeds, then we want to display successful status message.

On the other hand if there are data conflicts, and if the update fails, then we want to display failure status message. At the same time, we also want to retain the row in EDIT mode.

There are 3 steps to achieve this.
Step 1: In EmployeeDataAccessLayer class, change the return type of UpdateEmployee() method from "void" to "int"
public static int UpdateEmployee(int original_EmployeeId, string original_Name, string original_Gender, string original_City, string Name, string Gender,

string City)

ExecuteNonQuery() method of the command object, returns an integer indicating the number of rows updated. We want our UpdateEmployee() method to

return this value.
So, instead of "cmd.ExecuteNonQuery()" use "return cmd.ExecuteNonQuery()"

Step 2: Use "Updated" event handler of "ObjectDataSource1" control. This event is fired after the "Update" operation has completed, that is, after the execution of UpdateEmployee() method. Remember UpdateEmployee() method returns an integer back. Notice that we are checking if the "ReturnValue" is an integer. If it is an integer and greater than zero, then we are using the "RetunValue"(the value that is returned by UpdateEmployee() method) to initialize "AffectedRows" property. This "AffectedRows" property will be used in "GridView1_RowUpdated" event handler.

Step 3: Use "RowUpdated" event handler of "GridView1" control. Notice that we are using "AffectedRows" property to determine, if the update has succeeded or not. Remember this is the property that we initialized in Step 2.

To make things clear
1. First UpdateEmployee() method gets executed, and this method returns an integer value indicating the number of rows updated.
2. Then "Updated" event of "ObjectDataSource1" control is invoked. In this event handler method, we retrieve the value returned by "UpdateEmployee()"

and then use it to initialize "AffectedRows" property.
3. Finally "RowUpdated" event of "GridView1" control is invoked. In this event handler method, we use "AffectedRows" property to determine, if the update

has succeeded or not.

Make sure to include a "Label" control on your webform with ID=lblMessage.

asp.net core docker Keep gridview in edit mode when update fails due to data conflict - Part 20
43 Likes	43 Dislikes
24,401 views views	524K followers
Education	Upload TimePublished on 10 Mar 2013

Related keywords

wcf vs web api,ado.net core,sql server management studio,webkinz,webadvisor,craigslist nj,gridview datasource,wcf one piece,asp.net core 3,ajax players,weber grill parts,webtoon,tutorials by hugo,csharp corner,mvc design pattern,asp.net machine account,update datatable column value in c#,servers for minecraft,asp.net core dependency injection,ado.net tutorial,update data laravel,services angular,concurrency of evangelion,ajax ontario,concurrency vs parallelism,asp.net mvc tutorial,update data in codeigniter,asp.net cos'è,concurrency and computation practice and experience,csharp assembly,concurrency control,tutorialspoint python,sql join,concurrency programming,services briefcase,asp.net core web api,ajax jquery,wccftech,craigslist ny,gridview flutter,asp.net zero,csharp foreach,server memes,sql date format,services online,chase,update database asp.net core,serverless architecture,server resume,wcf c#,server books,tutorialspoint javascript,gridview rowcommand,mvcc connect,ado.net mysql,services technologies gps,concurrency in os,ajax deadpool,concurrency definition,update data in mysql,update datagridview c#,server jobs,cvs,website,mvc tutorial,costco hours,wcf service application,update data profile iphone,tutorialspoint spring,serverless,wcf soap,wcf cat,cool math games,wcf test client,concurrency in python,services & training hse colombia sas,servicestack,citibank,asp.net core identity,sql union,ajax parking,sql database,asp.net core logging,concurrency control techniques,update datatable,gridview devexpress c#,mvconnect,cunyfirst,asp.net guida,wcf nba,csharp download,wcfi foundation,csharp online,wcf authentication,tutorials near me,http://asp.net,server 2019,chernobyl,ado.net descargar,web of dreams,serverminer,gridview pagination,ajax cleaner,ado.net visual studio 2019,webassign,ado.net vs entity framework,ado.net visual studio 2017,csharp list,gridview height,sql like,asp.net mvc,asp.net core tutorial,sqlite,wcfm,gridview c#,ajax roster,mvc architecture,http://ado.net,concurrency meaning in hindi,asp.net core mvc,ajax soccer,server hosting,wcfi,concurrency in tagalog,ajax dish soap,capital one,server rack,tutorialspoint html,csharp interface,craigslist,concurrency interview questions,webroot,tutorialspoint reactjs,ajax request,wcf dragon ball,asp.net core 2.2,tutorialspoint python 3,sql developer,webster,services transmission company sas,sql group by,gridviewrow,asp.net core signalr,services manager,mvc framework,ajax paving,mvc near me,concurrency testing,tutorialspoint spring boot,mvc map,concurrency golang,csharp online compiler,asp.net download,sql between,ado.net c# pdf,services tag dell,concurrency inc,wcf 2019 nba,csharp switch,ado.net ventajas y desventajas,csharpstar,wcf tutorial,tutorialspoint,ajax meaning,csharp-video-tutorials.blogspot,tutorials dojo,central park 5,csharp string format,ado.net c#,asp.net core github,gridview android example,server status,ajax fc,server jobs nyc,asp.net core swagger,sql formatter,credit karma,services group,gridview css,gridview yii2,server error in '/' application,concurrency formula,services windows,asp.net core 3.0,sql injection,gridview asp.net,tutorialspoint c#,wcf ria services,calculator,ado.net entity data model,sql insert,tutorialspoint tableau,update database c#,services google play apk,sqlyog,update data attribute jquery,asp.net core 3 release date,sql server,server job description,tutorials by a,servicenow,webcam,mvc hours,webmd symptom,csharp array,csharp enum,ajax call,asp.net core 2. guida completa per lo sviluppatore,asp.net core,gridview c# asp.net,server pro,server status ffxiv,cheap flights,webcrims,asp.net core hosting,services sas,tutorialspoint java,tutorialspoint java compiler,webmd,csharp to json,college football,ado.net dataset,csharp dictionary,concurrency problems,cnn,website builder,tutorialspoint sql,update database php,asp.net web api,server side rendering,weber grills,update data using modal,concurrency meaning,sql server 2017,update database,tutorialspoint spark,mvc nj,ado.net oracle,asp.net core download,csharp to vb.net,update datagridview vb.net,webster bank,gridview column width,webstaurant,tutorialsystems,ajax post,services fms publish announcement,gridview devexpress,services.msc no abre,update data firestore,ajax jersey,csharp operator,asp.net core razor pages,server duties,asp.net core environment variables,csharp random,century 21,services consultores,services consulting,gridview hide column,mvcsd,services.msc,mvcsc,ado.net pdf,asp.net core configuration,ajax marvel,sql update,asp.net tutorial,mvc medical,ado.net entity data model visual studio 2019,wcfs international curriculum,mvc2,ado.net entity data model visual studio 2017,chase online,update database django,concurrency patterns in c#,wcf api,costco,server jobs near me,webex,gridview bootstrap 4,sql meaning,sql tutorial,update data profile,sql commands,ado.net entity framework,ajax tavern,tutorialsteacher,ajax javascript,update data type sql,services desk,update data in mongodb,ajax greek,csharp tutorial,mvc pattern,ado.net sql server,ado.net connection,asp.net identity,mvcu,gridview android,gridview bootstrap,update database laravel,asp.net core middleware,wcf web service,gridview xamarin forms,concurrency java,mvc webadvisor,web store,mvcc,webmail,mvci,mvctc,