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 a Project On Visual Basic
How To Save a Project On Visual Basic. ... How to Save an Image to a Database With MS Visual Basic 6....
How to Insert Data Into Access Using VB.Net
Knowing how to insert data into Access using Visual Basic.NET can save you ... Access database ... code to your ... an...
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 Connect Visual Basic to SQL
How to Connect Visual Basic to SQL. ... and use an ADO connection to SQL Server can save you time when you...
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 Save Messages on a BlackBerry
The BlackBerry is a smart phone which allows you access to email and the Internet. ... How to Save Pictures Using a...
How to Export a VB 6.0 Data Report Into PDF or Word
How to Save an Image to a Database With MS Visual Basic 6; Comments. 100000233496643 Feb 05, 2012. ... How to Save...
How to Add a Record With SQL
How to Add a Record With SQL. SQL is a database management ... Relational databases use structured query language ... How to...
Visual Basic: How to Set an Image Array to a Picture
Click on the ImageList1 on your form and click the "Images" option from the Properties window. ... How to Make a Gallery...