ASP .NET2 Updating SQL Record
Posted on 2006-04-19
I want to update a field in a record when the users selects that record. This is to record the number of 'clicks' a record gets. It sounds like it should be simple enough, but I am using ASP .NET2 and I am struggling. My code is:
Dim myval, mysql As String
myval = GridView1.SelectedDataKey.Value
mysql = "UPDATE supplier_details SET(clicks = (clicks + 1) WHERE (user_ID = '" + myval + "')"
EOLUpdate.UpdateCommand = mysql
but this returns an error 'In order to evaluate an indexed property, the property must be qualified and the arguments must be explicitly supplied by the user'
I have trawled the help pages and tried several versions of the code, but can not get things to work :(