Different types in Updating Sharepoint List

            While creating Event Receivers or Workflows we need to update the list or list items using SPListItem method. However there are different types in updating. Most commonly used are Update and SystemUpdate. lets see the different types of updates and its use.

Update()

• Updates the item in the database.
• Updates the “Modified” and “Modified by” values.
• Creates a new version.

Systemupdate()

• Updates the item in the database(List).
• Does not update build in columns "Modified" and "Modified By".
• Does not increment item version.
• Triggers the item events.

Systemupdate(true)

• Updates data to database(List).
• Does not update build in columns "Modified" and "Modified By".
• Will increment Item Version.

Systemupdate(false)

• Updates data to database.
• Does not update build in columns "Modified" and "Modified By".
• Does not increment item version.

UpdateOverwriteVersion()

• Updates data to database.
• Updates build in columns "Modified" and "Modified By".
• Does not increment new version.

Note :

You can also disable the triggering of events by using “this.EventFiringEnabled = false;”. Do your update and enable the events again with “this.EventFiringEnabled = true;”