Solved

How do I save an image to SQL that I have pasted into a picturebox via the clipboard?

Posted on 2014-10-06
2
819 Views
Last Modified: 2014-10-13
I have a picturebox on my WinForm.  The user inputs an image and it is saved into SQL.  

If the saved image is a file and the user does this, the picture is saved and retrieved from SQL perfectly.  

To input the image:
Dim openFileDialog As New OpenFileDialog

If openFileDialog.ShowDialog() = System.Windows.Forms.DialogResult.OK Then
            PictureBox1.Image = System.Drawing.Image.FromFile(openFileDialog.FileName)
End If

To save the image:
If PictureBox1.BackgroundImage IsNot Nothing Then
                Dim ms As New MemoryStream()
                PictureBox1.BackgroundImage.Save(ms, PictureBox1.BackgroundImage.RawFormat)
                Dim data As Byte() = ms.GetBuffer()
                tblH.errImage = data
End If

To retrieve the image:
If tblH.errImage IsNot Nothing Then
Dim picImage = (tblH.errImage).ToArray()

If picImage.Length > 0 Then
                Dim stream As MemoryStream
                Dim img As System.Drawing.Image
                stream = New MemoryStream(picImage)
                img = System.Drawing.Image.FromStream(stream)
                PictureBox1.Image = img

            End If
Else
            Me.PictureBox1.Image = Nothing
            Me.PictureBox1.Refresh()
End If

But when I use the clipboard to insert the image, the system throws an error when I try to save it.  

This Is the error:
An unhandled exception of type 'System.ArgumentNullException' occurred in System.Drawing.dll
Additional information: Value cannot be null.

I am using this code to insert an image from the clipboard:

If My.Computer.Clipboard.ContainsImage Then
            PictureBox1.BackgroundImage = My.Computer.Clipboard.GetImage
            PictureBox1.BackgroundImageLayout = ImageLayout.Zoom
Else
            MsgBox("Your clipboard does not contain an image.")
End If

If I change backgroundimage to image, it does the same thing.   I also see there is a value in PictureBox1.BackgroundImage.RawFormat so I don't understand the null value error.

I'm not sure where to check next so any direction will be greatly appreciated!
Many thanks!!
0
Comment
Question by:Karen Wilson
2 Comments
 
LVL 12

Accepted Solution

by:
ktaczala earned 500 total points
Comment Utility
This line is your problem:
PictureBox1.BackgroundImage.Save(ms, PictureBox1.BackgroundImage.RawFormat)

Try This:
PictureBox1.BackgroundImage.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg) ' or whatever format you want.
0
 

Author Closing Comment

by:Karen Wilson
Comment Utility
Worked perfect!!  Thanks so much.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

This article shows how to convert a multi-page PDF file into multiple image files, with one image file created for each page of the PDF. It does this by utilizing an excellent, free software package called GraphicsMagick. The solution is amazingly s…
You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
Users will learn how resize a batch of photos from a single command in Photoshop via Photoshop's Image Processor. Open up an Image you'd like to resize in Adobe Photoshop: Adjust the image size according to your preferences. Image > Adjustments > …
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now