VB.NET: image database

[oren18]

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.

[Hansi65]

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.

[oren18]

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 ?