Storing images in databases

Question

0.00/5 (No votes)

See more:

How we can add images to databases so that we can use the images in vb while preparing crystal report?
Is there any procedure for that?

Please guide me exactly.

Thanks.

Posted 3-May-11 20:27pm

Member 7894677

Updated 3-May-11 21:35pm

Dalek Dave

v4

Add a Solution

Comments

Sergey Alexandrovich Kryukov 4-May-11 2:43am

I modified the title because "To install" seems to be inapplicable; could be just wrong English usage. Is that what you mean to ask?
--SA

Dalek Dave 4-May-11 3:35am

Edited for Grammar, Syntax and Readability.

3 solutions

Solution 2

Try
How can I store images (or other files) in a database[^] to learn step by step process to save Image in Database.

Posted 3-May-11 21:06pm

RaviRanjanKr

Comments

Dalek Dave 4-May-11 3:36am

Good Link.

RaviRanjanKr 4-May-11 5:51am

Thanks DD.

Tarun.K.S 4-May-11 4:39am

Good link Ravi! +5

RaviRanjanKr 4-May-11 5:51am

Thanks Tarun.

Solution 3

try this link also

Click[^]

Posted 3-May-11 21:38pm

Mahendra.p25

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

^That's **Aragon** · Accepted Answer · 2011-05-03T20:57:00

1. Don't save whole image in database. It is not a good approach.
2. Save your image at any folder of your project/website and save its path to the database.

VB

If file.PostedFile.ContentLength > 0 Then ''// Upload file if length > 0
         Dim strExt As String
         strExt = IO.Path.GetExtension(file.PostedFile.FileName) '// Get Extension
         If imageName = "" Then '// change name if not specify
             strImgName = Trim(Now.Year.ToString & Now.Hour.ToString & Now.Minute.ToString & Now.Millisecond.ToString & imageName) '// So that image can not be duplicate
             strImgName = strImgName & strExt
         Else
             strImgName = imageName & strExt '// take given name
         End If
         If Not (checkExt(file.PostedFile.FileName, ".jpg") Or checkExt(file.PostedFile.FileName, ".gif") Or checkExt(file.PostedFile.FileName, ".png")) Then
             lblMsg.Text = "Upload only .gif,.png or .jpg file format."
             lblMsg.Visible = True
             Return ""
         End If
         If strImagePath <> "" Then
             If System.IO.Directory.Exists(strImagePath) Then file.PostedFile.SaveAs(strImagePath & strImgName)
         End If
     Else
         strImgName = "" '// file uplaod has no image uploaded
     End If

3. For displaying image in the crystal report, Reference-1[^] and Reference - 2[^]

Hope it helps.