This post is part of a series dedicated to database access. This is the stored procedure (SP) that updates a row in the database.
It's fairly straightforward to do this SP. It receives the value of all columns of the datatable that it has to update. The program knows which ones are pure data and which column is the primary key (PK). The PK has to go in the WHERE part of the SQL sentence in order to affect only one row of the datatable. In this SP the PK is always an input parameter, in the INS SP it was an output parameter.