You have specified that your update command compares all values on SqlDataSource AccessDat

Hi Pardeew,

My experience with the ConflictDetection goody is that if you set it to CompareAllValues at designtime a Update-query is automaticly generated where each field is added to the WHERE part as "[x] = @.old.." and also for each field a UpdateParameter is added.

I assume you did change this Update-query manually to the one you posted above and you also deleted the autogenerated UpdateParameters.

So set the the ConflictDetection to OverwriteChanges or remove the declaration from you aspx.

thank you very much.

i changeConflictDetection=CompareAllValuestoOverwriteChangesand it works.