I added a dateDiff to my sql statement:
dateDiff('d', recevDateBillSent, NOW()) AS DiffDate
My dataset is binding to my datagridview, this date difference field has been added as an extra column in my datagridview, but when I try to update other columns in my dataset there is a Concurrency violation: the UpdateCommand affected 0 of the expected 1 records.
I'm guessing it is because vb.net is trying to save the dateDiff column in to my database but there is no column to save to because it is created through the sql statement.
Is there a way around this?