Click here to Skip to main content
15,867,756 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi! I was just wondering if you had any suggestions for how I might store a picture that a user had entered into a Microsoft Access database and display them using vb.net Flowlayout. I simply want to know if my conception of this is implausible. Please consider my request. Thankyou! Thankyou!

PS. Any opinion/source will do.
PSS. It would be really helpful if you have any recommendations besides flowlayout.

What I have tried:

-----THIS IS JUST A QUESTION------
Posted
Updated 5-Nov-22 0:31am

1 solution

Yes, you can do it: just use a BLOB field, and store it via a parameterised query.

There is code (for SQL Server, but teh Access command is pretty similar) here: Why do I get a "Parameter is not valid." exception when I read an image from my database?[^]
It's C# code, but here is an online converter: Code Converter C# to VB and VB to C# – Telerik[^]
You can use pretty much any control to display them: FlowLayout, DataGridView, ... whatever suits your application.

Do be aware that if images get large and numerous then you will use significant amounts of DB space and bandwidth: you might want to consider out-of-DB image storage with a thumbnail in the DB which you "expand" when the user wants a proper look at an individual image.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900