How to add multiple images to sqldb Image field

Priyantha Niroshan 21

Dear All,
I have a SQL database call Books, containing the following fields.

ID [int]
Name varchar(50)
Author varchar(30)
Pic1 [image]
Pic2 [image]
Pic3 [image]
Active [bit]

I want to add 3 images to my SQL database using vb.NET. These images will be selected by the user via a common dialog box.

can someone help me with the sample code, please?

Thank you.
Rgds,
Niroshan.

Dan Guzman 9,206 Reputation points

2021-08-08T13:23:48.297+00:00

Add a dotnet-visual-basic since your question is about to VB.NET programming. Also, do not use the deprecated image data type for new SQL Server development. Use VARBINARY(MAX) Instead.
Priyantha Niroshan 21 Reputation points

2021-08-09T01:42:18.71+00:00

Thank you!

Accepted answer

Viorel 112.1K Reputation points

2021-08-08T13:52:07.23+00:00

See how the @photo parameter is used to insert an image together with other details: https://learn.microsoft.com/en-us/dotnet/framework/data/adonet/sql/inserting-an-image-from-a-file. You will have three such parameters. To load the array of bytes, use File.ReadAllBytes.

The technique can be also used with UPDATE statement.
Please sign in to rate this answer.

1 person found this answer helpful.
Priyantha Niroshan 21 Reputation points

2021-08-09T01:42:03.19+00:00

thanks! Much appreciated.

Priyantha Niroshan 21 Reputation points

2021-08-09T05:34:41.957+00:00

One issue,
vb.NET does not have such thing called

byte[] photo = GetPhoto(photoFilePath)
how to get the pic to a variable ?

Priyantha Niroshan 21 Reputation points

2021-08-09T06:05:18.007+00:00

Got it!!!

Dim mStream As New MemoryStream()
picBox.Image.Save(mStream, System.Drawing.Imaging.ImageFormat.Jpeg)
Dim b() As Byte = mStream.ToArray()

cheers !! : )
Sign in to comment

0 additional answers