By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,719 Members | 1,036 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,719 IT Pros & Developers. It's quick & easy.

VB.NET: image database

P: 3
hello.does anybody know ..

how to make an image database by using VB.NET 2005 and Microsoft Access

i want to make an application ( VB.NET 2005 ) that prompt a user to put his picture into database (Mic. Access)

the database i've set have a pictures field , staff name , address and so on..

so in the VB i know how to build a connection to the database ..

the problem is how do i make image uploader .. into database.


hope anybody can help me.
Nov 7 '06 #1
Share this Question
Share on Google+
2 Replies


P: 13
Hi there,

my suggestion is not a solution to your question, more a workaround...

First of all there is the question: is it really necessary to put the image data inside your database?

The answer is usually NO, until you are planning sophisticated solutions including replication and the like. Image data can not be used for sorting, indexing or anything else what makes handling data in a database efficient.

Suggestion: use another "database system" already on your computer, the file system.

Suppose your users are listed in a table named USERS and indexed with a primary key named UserID.

Simply create a subfolder named PICTURES where your database resides and put your users images there with a fixed name derived from UserID, like Picture17.JPG.

Then you can use the frameworks standard commands like Image.Save and Image.FromFile to access your picture data and there is no need to fiddle with binary data in access tables.
Nov 8 '06 #2

P: 3
Hi there,

my suggestion is not a solution to your question, more a workaround...

First of all there is the question: is it really necessary to put the image data inside your database?

The answer is usually NO, until you are planning sophisticated solutions including replication and the like. Image data can not be used for sorting, indexing or anything else what makes handling data in a database efficient.

Suggestion: use another "database system" already on your computer, the file system.

Suppose your users are listed in a table named USERS and indexed with a primary key named UserID.

Simply create a subfolder named PICTURES where your database resides and put your users images there with a fixed name derived from UserID, like Picture17.JPG.

Then you can use the frameworks standard commands like Image.Save and Image.FromFile to access your picture data and there is no need to fiddle with binary data in access tables.
are there any tutorial link .. like like you said ?
Nov 8 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.