Database Value

[m0foWnz0R]

I'm trying to get a value from an access database,that value being a number and add it to another number then update the database.I'm having troubles with "OldCount".

Dim ConnString As String = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=D:\My Data.mdb"

Dim SqlString As String = "Update FullAppDetails Set Downloaded = ?"
Dim NewCount As Integer = 1

Dim OldCount As Integer = <%# Eval("Downloaded") %>
Dim i As Integer = CInt(NewCount + oldcount)

Using conn As New OleDbConnection(ConnString)
Using cmd As New OleDbCommand(SqlString, conn)

cmd.CommandType = Data.CommandType.Text
cmd.Parameters.AddWithValue("Downloaded", i)

conn.Open()

cmd.ExecuteNonQuery()

End Using

End Using

[majk]

Hmm,seems to me you are trying to add 1 to an existing value in a column so here is what i suggest :

Update FullAppDetails Set Downloaded = Downloaded + 1 Where