DaniWeb IT Discussion Community - View Single Post

Re: upload image in vb.net

Dec 4th, 2008

That works. If you have an existing row to update. If you want to insert a new one, the code changes a bit:

 Help with Code Tags 
 VB.NET Syntax (Toggle Plain Text) 
Dim command As New SqlCommand("INSERT INTO MyTable (Picture) VALUES (@Picture); SELECT @@IDENTITY AS 'Identity'", connection)
Dim ThisPictureID As Integer
ThisPictureID = CInt(command.ExecuteScalar())
Dim command As New SqlCommand("INSERT INTO MyTable (Picture) VALUES (@Picture); SELECT @@IDENTITY AS 'Identity'", connection)
Dim ThisPictureID As Integer
ThisPictureID = CInt(command.ExecuteScalar())

Now ThisPictureID contains new ID.

Teme64 @ Windows Developer Blog