a few simple questions

thanks phil, how would i go about updating a value in my users table. I am currently executing a scalar to return the current image no for that user, and then incrementing it before saving the new image. Now i need to record the new current image no in the table and know i need an update statement, however i have never used one so far thanks

This is what i have come up with for an update statement. I am getting a syntax error when i execute the code. As i say i am not sure if this is the correct sql statement or not. ANy advice much appreciated thanks.

myConnection2.Open();

myCommand2.CommandText = "UPDATE [Users] SET [Image_no] VALUE(W8) WHERE User_Name = @W1";
myCommand2.Parameters.AddWithValue("@W8", Image_no);
myCommand2.Parameters.AddWithValue("@W1", CurrentUser);
myCommand2.ExecuteNonQuery();

myConnection2.Close();

thanks

I have solved my problem thanks for your help.