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
861 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

MIM Survival Guide for Service Desk Managers

Major incidents can send mastered service desk processes into disorder. Systems and tools produce the data needed to resolve these incidents, but your challenge is getting that information to the right people fast. Check out the Survival Guide and begin bringing order to chaos.

Question has a verified solution.

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

Suggested Solutions

Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
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 > …
In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…

738 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