Working With Pictures

[EdB]

Does anyone have any good examples of code for this type of situation?

I have a data table that stores information about individuals. I also have
the need to store a picture of the individual for display and ID badge
printing.

#1, I found it discouraging that the Picture Box control did not support
Drag And Drop. Any thoghts here?

#2, How do you store a picture to a SQL table?

Thanks in advance.

[Jorge Serrano [MVP VB]]

Hi,

the picturebox supports D&D.
You can try the 101 free samples of VB.NET. One sample uses D&D.
http://msdn.microsoft.com/vbasic/dow...s/default.aspx

To read and write a picture into database;
(read)
http://support.microsoft.com/kb/317670/EN-US/
(read & write with BLOB)
http://support.microsoft.com/kb/308042/EN-US/
(write)
http://www.theserverside.net/discuss...hread_id=24962

I hope that helps.

Kind regards,

Jorge Serrano
MVP VB.NET
"EdB" wrote:

Does anyone have any good examples of code for this type of situation?

I have a data table that stores information about individuals. I also have
the need to store a picture of the individual for display and ID badge
printing.

#1, I found it discouraging that the Picture Box control did not support
Drag And Drop. Any thoghts here?

#2, How do you store a picture to a SQL table?

Thanks in advance.

[Cor Ligthert]

EdB,

For the drag and drop see the samples on MSDN.

Here beneath my complete sample for everything with a Blob about reading and
writing to a Dataset (and with that to an SQL server) avoiding in my idea
some extra processing that is in the samples on MSDN.

http://groups.google.com/groups?selm...TNGP11.phx.gbl

I would use instead of complete images thumbnails for your problem, maybe
you can see the sample snippet bellow as an extention form the code in the
message above,

\\\
Dim arrImage() As Byte = DirectCast(rdr.Item("Photo"), Byte())
Dim ms1 As New System.IO.MemoryStream(arrImage)
Dim origimage As System.drawing.Image =
System.Drawing.Image.FromStream(ms1)
Dim PThumbnail As System.drawing.Image
PThumbnail = origimage.GetThumbnailImage(100, 100, Nothing, New IntPtr)
ms2 As New System.IO.MemoryStream
PThumbnail.Save(ms2, Imaging.ImageFormat.Bmp)
arrImage = ms2.GetBuffer
///

I hope this helps a little bit?

Cor

[EdB]

Thanks Jorge & Cor.

I'm sure the answers I seek are in your posts.

I based the following comment:

#1, I found it discouraging that the Picture Box control did not support
Drag And Drop. Any thoghts here?
On the fact that controls such as the TextBox have an AllowDrop property and
the picture does not.

Ed

"EdB" wrote:
Does anyone have any good examples of code for this type of situation?

I have a data table that stores information about individuals. I also have
the need to store a picture of the individual for display and ID badge
printing.

#1, I found it discouraging that the Picture Box control did not support
Drag And Drop. Any thoghts here?

#2, How do you store a picture to a SQL table?

Thanks in advance.

[Richard Myers]

Hello

#1, I found it discouraging that the Picture Box control did not support
Drag And Drop. Any thoghts here?
Its been a while since i have used the picture box control. Are you sure this is correct?
Picturebox inherits from control and so it would have available drag drop members associated with
it.
#2, How do you store a picture to a SQL table?

You basically just split your image into a byte array and store that in the db.

Heres and example:

http://www.dotnet247.com/247referenc...ashCardsMG.asp