Your database saves images in binary form, so you can display the images on a webpage or Windows form. The Visual Basic language has a connection syntax that allows you to connect to the database, specify that the information is an image and store it in one of your tables. The image can be one from a webpage or located on the local hard drive. Images are large objects, so the tables need sufficient space to store the binary files. With enough hard drive space, you can create a large image repository for your Visual Basic 6 application.
Create a memory stream object and assign it to the image. The memory stream reads the binary data from the image and stores it in memory. This binary data is later transferred to a binary array. The following code creates the memory stream and saves the image:
Dim ms As new MemoryStream()
"theImage" is the ID of the image located on your Visual Basic form. This image element points to a location of an image on the hard drive.
Create the database connection and SQL query that inserts the image into the database. The connection you create is dependent on the server you use. The following code sets up the connection and creates the "insert" query:
Dim conn As New SqlConnection(string_connection)
Dim query As String = "insert into Picture_Table (picture) values (@Picture)"
Dim command As New SqlCommand(query, conn)
Set up the image parameter for the query command. The following code sets up a parameter for the SQL code and attaches the image:
Dim byteArray() As Byte = ms.GetBuffer()
command.Parameters.Add(New SqlParameter("@Picture", SqlDbType.Image)).Value = byteArray
Execute the query and save the image to the database. All the parameters are set up, but the image is still not saved to the database. The code below opens the database connection, executes the SQL code and saves the image to the database table:
- Photo Credit digital image image by peter Hires Images from Fotolia.com
How to Save Messages on a BlackBerry
Most people who own a BlackBerry are addicted. The ease and convenience of the BlackBerry makes those who do not have one...
How to Play MP3 Files in Visual Basic 6.0
Visual Basic has internal classes that easily assist you in coding audio applications. Media Player is a Windows application that can be...
How to Make a Visual Basic Image Uploader
Creating an application in Visual Basic is a fairly easy task that can be accomplished even in the free "Express" version of...
How to Insert Data Into Access Using VB.Net
Knowing how to insert data into Access using Visual Basic.NET can save you time when you need to add multiple records manually....
Visual Basic: How to Set an Image Array to a Picture
Images help to make any computer program stand out. Whether you design a card game or a photo album or even a...
How to Export a VB 6.0 Data Report Into PDF or Word
Visual Basic 6.0 is an application that allows you to create Windows-based applications using a variation of the Basic programming language. You...
How to Add a Record With SQL
SQL is a database management program with one of the most popular versions being the open source MySQL. SQL uses a special...
How To Save a Project On Visual Basic
While developing a Visual Basic project, save regularly so you do not lose any data. The default location where your Visual Basic...
How to Connect Visual Basic to SQL
As a programmer you will run into the need to connect to multiple data sources such as SQL databases. Once you make...