// handles any data type and nulls
public static void UpdateColumnByKey(string table, string dataColumn,
object dataValue, string keyColumn, object keyValue)
{
var sql =
$"UPDATE {EncloseName(table)} SET {EncloseName(dataColumn)}=@p1" +
$" WHERE {EncloseName(keyColumn)}=@p2";
using (var cn = Current.Connection)
{
cn.Open();
var cmd = Current.Command(sql, cn);
cmd.CommandTimeout = 3600;
Current.AddCommandParameter(cmd, "p1", dataValue);
Current.AddCommandParameter(cmd, "p2", keyValue);
cmd.ExecuteNonQuery();
}
}