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
852 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
ID: 40375694
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
ID: 40377311
Worked perfect!!  Thanks so much.
0

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In a previously published article (http://www.experts-exchange.com/articles/10331/Automatic-Duplex-Scanning-in-PaperPort-Versions-11-12-14.html) here at Experts Exchange, I explained how to achieve duplex (double-sided) scanning in Nuance's PaperPor…
This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
The goal of the tutorial is to teach the user what gradient filters are and how to use them. When you have a photo and some part of the photo is either over exposed or under exposed, you use a gradient filter to help mask the need to touch up th…
The goal of the tutorial is to teach the user the full work flow of how to use flash media encoder to stream onto YouTube.

830 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