Solutions I tried: 1. set HighlightTextBrushKey to x:Null or Transparent in data grid resources. … 2. Change color of HighlightTextBrushKey on Selected event of DataGridRow. this works only when this event and not every-time when foreground color’s trigger is fired.
Day: August 21, 2023
I’m not familiar with MSSQL, but with other databases, I would suggest attempting to insert the new record (assuming there is a unique key to prevent duplicate records) and then either catch (if I cared) or ignore (if I don’t care) the duplicate key exception and then issue the UPDATE; or attempt the update, check the number of rows affected, and if it was zero, run the insert.
