Vb.NET Insert Image File to Picturebox and store it to database.mdf

Question

I have a table which have image data type in one of the colomn , I try this code,

first, is this a right code to insert one row of the table?

Me.DatasiswaTableAdapter.Insert(NISTextBox.Text, NamaTextBox.Text, KelasTextBox.Text, JurusanTextBox.Text, Jenis_KelaminComboBox.Text, Tanggal_LahirDateTimePicker.ToString, AlamatRichTextBox.Text, FotoPictureBox.Image)

if yes then I need to know why the image type is change to byte? and how to insert the image from picturebox if the format of the code is a byte?
then if no please let me know the right code

Sorry for my bad English :) Thanks

can you give me a sample with your own statement, so i can try it to my script — Bondan's Blackk Diamond
– Bondan's Blackk Diamond, Commented Oct 15, 2013 at 7:50
i got this, net-informations.com/vbprj/dataset/insert-image.htm can you tell me what is this mean? cmd.Parameters.AddWithValue("@id", id) — Bondan's Blackk Diamond
– Bondan's Blackk Diamond, Commented Oct 15, 2013 at 9:49

Ňɏssa Pøngjǣrdenlarp · Accepted Answer · 2013-10-15 12:55:10Z

1

the net-informations link you posted should be very helpful if you study it.

it means a)the column you want to store the image to in SQL server must be defined as image. If you are using a different DB such as Access, depending on the version you might need to define it as Object or something similar. b) in the example, the image is converted to a stream (using image.save) then the stream to a byte array for storing in the DB.

you may want to store a bit more information about the image. getting it back to an image will just be the reverse (db -> byte array -> stream), but you are not going to know whether it was JPG, PNG, TIFF etc. If you think you will ever want to recreate it as a disk file in its original format, store the MIME type as well.

answered Oct 15, 2013 at 12:55

Ňɏssa Pøngjǣrdenlarp

39k12 gold badges66 silver badges193 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Bondan's Blackk Diamond Over a year ago

wow,there are many things I don't know,perhaps I'll learn it from that link about converting image to byte by stream,.

Collectives™ on Stack Overflow

Vb.NET Insert Image File to Picturebox and store it to database.mdf

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related