The below is the related code ,but pls remember to clear the image column in updateCommand 's syntax,and updateparams in aspx file.
If you don't clear it , the sqlcommand will reexecute it. and it'll produce a error.
Public Sub UpdatePhoto(ByVal Id As Integer, ByVal PhotoFile As FileUpload)
If (PhotoFile Is Nothing) Or (Not PhotoFile.HasFile) Then
Return End If Using cn As New SqlConnection(GlobalVarible.ConnectionString) Using cmd As New SqlCommand( "update StaffDemo set Image=@Image where id=@ID" , cn)cmd.Parameters.Add(
"ID" , Data.SqlDbType.Int).Value = Idcmd.Parameters.Add(
"@Image" , Data.SqlDbType.Image).Value = PhotoFile.FileBytescn.Open()
cmd.ExecuteNonQuery()
End Using End Using End Sub