Insert Image into Access DB

[mchoudhury]

Hi Guys,
I'm trying to insert a image into an Access DB, but having bit of a problem sorting the backend codeing. Can someone look at it and tell me how would i amend this inorder to accept image:

Dim PictureCommand As OleDbCommand

Dim InsertBye As Byte = "INSERT INTO Properties ([Picture1]) Values (@Picture1)"

PictureCommand = New OleDbCommand(InsertBye, MyConnection)

PictureCommand.Parameters.Add(New OleDbParameter("@Picture1", OleDbType.VarBinary, 150))
PictureCommand.Parameters("@Picture1").Value = Server.HtmlEncode(Picture1.FileName)

If this is wrong coding, can someone kindly write me a script where images would be inserted into an access DB

Thank You,
Mac

 

[ca8msm]

Try this:

http://www.stardeveloper.com/articles/display.html?article=2003031201&page=1

____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[mchoudhury]

I had a look at the site, did not really help me as i could not transfer the script in to my coding. C# is not a strong skills of mine. Any other idea

 

[jbenson001]

You can covert it to VB easily...
Use this site:

http://www.developerfusion.co.uk/utilities/convertcsharptovb.aspx