asp.net core docker ConflictDetection property of objectdatasource control - Part 16

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 Part 15 of the asp.net gridview tutorial we discussed about deleting data from gridview control using objectdatasource control. We did not discuss about concurrency in Part 15. Let me explain what I mean.
1. When you access the webform, data is loaded into gridview control.
2. While you are looking at this data in the gridview control, someone else has updated a row in the database table
3. Now, in the gridview, when you click the delete button on the row that has changed, the row gets deleted.

This may be fine in most cases. However, let's say we don't want to allow the row to be deleted, in case if it has changed, then, we can make use of ConflictDetection property of the objectdatasource control.

We will be modifying the "DeleteEmployee()" method in EmployeeDataAccessLayer.cs file. We discussed about this in Part 15. Please change the implementation of DeleteEmployee() method as shown below. Notice that the ORIGINAL EmployeeId, Name, Gender and City are now passed as parameters to the DeleteEmployee() method. These parameters are then used in the "DELETE" query, to check if the data has changed after it was loaded into the gridview control.
public static void DeleteEmployee(int original_EmployeeId, string original_Name, string original_Gender, string original_City)
{ string CS = ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString; using (SqlConnection con = new SqlConnection(CS)) { string deleteQuery = "DELETE FROM tblEmployee WHERE EmployeeId = @original_EmployeeId " + "AND Name = @original_Name AND Gender = @original_Gender AND City = @original_City"; SqlCommand cmd = new SqlCommand(deleteQuery, con); SqlParameter paramEmployeeId = new SqlParameter("@original_EmployeeId", original_EmployeeId); cmd.Parameters.Add(paramEmployeeId); SqlParameter paramName = new SqlParameter("@original_Name", original_Name); cmd.Parameters.Add(paramName); SqlParameter paramGender = new SqlParameter("@original_Gender", original_Gender); cmd.Parameters.Add(paramGender); SqlParameter paramCity = new SqlParameter("@original_City", original_City); cmd.Parameters.Add(paramCity); con.Open(); cmd.ExecuteNonQuery(); }
}

Compile the project and re-configure ObjectDataSource1 control, to use the above method as it's DELETE method.

Finally on "ObjectDataSource1" control, set properties
ConflictDetection="CompareAllValues"
OldValuesParameterFormatString="original_{0}"

Setting ConflictDetection="CompareAllValues", will pass original values for EmployeeId, Name, Gender and City to DeleteEmployee() method.

Notice the parameters of the DeleteEmployee() method. All of them have a prefix of "original_". ObjectDataSource control uses "OldValuesParameterFormatString" property to figure out the exact name of the parameters for the original values. This is the reason we have set OldValuesParameterFormatString="original_{0}"
public static void DeleteEmployee(int original_EmployeeId, string original_Name, string original_Gender, string original_City)

asp.net core docker ConflictDetection property of objectdatasource control - Part 16
36 Likes	36 Dislikes
16,196 views views	524K followers
Education	Upload TimePublished on 6 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,servers for minecraft,asp.net core dependency injection,ado.net tutorial,services angular,concurrency of evangelion,ajax ontario,concurrency vs parallelism,asp.net mvc tutorial,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,serverless architecture,server resume,wcf c#,server books,gridview rowcommand,tutorialspoint javascript,mvcc connect,ado.net mysql,services technologies gps,concurrency in os,ajax deadpool,concurrency definition,server jobs,cvs,website,mvc tutorial,costco hours,wcf service application,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,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,gridview height,csharp list,sql like,asp.net mvc,asp.net core tutorial,sqlite,gridview c#,wcfm,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,services google play apk,sqlyog,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,gridview c# asp.net,asp.net core,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,asp.net web api,server side rendering,weber grills,concurrency meaning,sql server 2017,tutorialspoint spark,mvc nj,ado.net oracle,asp.net core download,csharp to vb.net,gridview column width,webster bank,webstaurant,tutorialsystems,ajax post,services fms publish announcement,gridview devexpress,services.msc no abre,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,concurrency patterns in c#,wcf api,costco,server jobs near me,webex,gridview bootstrap 4,sql meaning,sql tutorial,sql commands,ado.net entity framework,ajax tavern,tutorialsteacher,ajax javascript,services desk,ajax greek,csharp tutorial,mvc pattern,ado.net sql server,ado.net connection,asp.net identity,gridview android,mvcu,gridview bootstrap,asp.net core middleware,gridview xamarin forms,wcf web service,concurrency java,mvc webadvisor,web store,mvcc,webmail,mvci,mvctc,