Updating image in VB and SQL Server not working [closed]

by

There are other things wrong with that code but I’ll concentrate on the two that most directly pertain to your stated issue.

Firstly, you have this within your SQL code:

Img =  '@Spic'

That is wrong. If you want to use the value of a variable in VB, would you wrap the name of the variable in double-quotes? Of course you wouldn’t! That would use a String containing the name of the variable rather than the value of the variable itself. With that in mind, why would you wrap the name of a SQL parameter in single-quotes when the purpose of single-quotes in SQL is specifically to denote a literal string?

Even if you fix that though, it’s still not going to work because of this:

da.UpdateCommand.Parameters.Add(New SqlClient.SqlParameter("@Spic", SqlDbType.Image)).Value = IO.File.ReadAllBytes(ofd.FileName)

da.UpdateCommand = New SqlCommand

You add a parameter to the command object that is currently assigned to the UpdateCommand property, then you immediately discard that command object and replace it with a new one. If you have a bowl of ice cream and you put chocolate sprinkles on it, then toss the ice cream and put a new scopp in the bowl, would you be surprised that there are no chocolate sprinkles on it? Of course not. That’s exactly what you would expect, so why would you think that it would be any different here?

More Related Contents:

  1. incorrect syntax near keyword where [closed]
  2. Query to list number of records in each table in a database
  3. Storing a file in a database as opposed to the file system?
  4. Use float or decimal for accounting application dollar amount?
  5. Multiple Indexes vs Multi-Column Indexes
  6. Preferred Method of Storing Passwords In Database
  7. Using a sort order column in a database table
  8. How to do version control for SQL Server database?
  9. What columns generally make good indexes?
  10. How to determine total number of open/active connections in ms sql server 2005
  11. How to check if a database exists in SQL Server?
  12. Getting execute permission to xp_cmdshell
  13. TSQL: Create a view that accesses multiple databases
  14. How to migrate a PostgreSQL database into a SQLServer one?
  15. “Cannot open user default database. Login failed.” after installing SQL Server Management Studio Express
  16. How to create a yes/no boolean field in SQL server?
  17. Best way to store time (hh:mm) in a database
  18. How can I run just the statement my cursor is on in SQL Server Management Studio?
  19. Executing set of SQL queries using batch file?
  20. Database design: Calculating the Account Balance
  21. In SQL Server, how can I lock a single row in a way similar to Oracle’s “SELECT FOR UPDATE WAIT”?
  22. Date range overlapping check constraint
  23. What are the advantages of VistaDB
  24. Difference between database and schema
  25. Generate table relationship diagram from existing schema (SQL Server) [closed]
  26. Calculate Time Difference Between Two Rows
  27. What are the limitations to SQL Server Compact? (Or – how does one choose a database to use on MS platforms?)
  28. How do you deal with blank spaces in column names in SQL Server?
  29. Display varbinary Image in Gridview
  30. Tool for Scripting Table Data

Leave a Comment