Binary read jpeg and store it in SQL Server db

Question

I have a jpeg file in my C drive from my vb.net application I want to binary read it and store it in SQL server. How can I do that? Thanks

SLaks · Accepted Answer · 2010-01-11 19:24:06Z

1

You can read a file into a byte array by calling File.ReadAllBytes.

You can then put the byte array into SQL Server using a SqlParameter.

For example:

Using command As New SqlCommand("INSERT INTO sometable VALUES(@image)", connection)
    command.Parameters.AddWithValue("image", File.ReadAllBytes(path))
    command.ExecuteNonQuery()
End Using

answered Jan 11, 2010 at 19:24

SLaks

891k182 gold badges1.9k silver badges2k bronze badges

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

2 Comments

acadia Over a year ago

Thanks sLaks. One question. the image is not in my C drive it is in a location on the server how can I read it like My.Computer.FileSystem.ReadAllBytes _ ("C:/Documents and Settings/selfportrait.jpg") This is the location of the files Server.MapPath("images\Signatures\") & Session("NetworkID").ToString() & ".jpeg")

SLaks Over a year ago

As long as it's on a local disk, you can still read it. If it was uploaded by the user, you can also get a byte array by reading Request.Files[0].InputStream or the FileBytes property of the FileUpload control.

Collectives™ on Stack Overflow

Binary read jpeg and store it in SQL Server db

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related