how to view photos.

Question

User1216460367 posted

Hi,

Im doing a school record program for my class, studen_id, name.... 

I have a database in access with a OLE field.

I need the easy way to view the photos or link that are store in my database

in a web form, Ex. formview or other.

 

I know that access is not the best way to go, but I only need to show 5 record with photos.

 

If you know any help link, let me know

Im new on this, so I need step by step instructions.

 

Thanks,

Sammy

Answer 1

User-304147557 posted

Sammy,

Check this http://photohandler.codeplex.com/

Answer 2

User-1199946673 posted

http://www.mikesdotnetting.com/Article/123/Storing-Files-and-Images-in-Access-with-ASP.NET 

Answer 3

User-216961763 posted

Hi,

U need to Upload the Photos On a Single Direcotry with StudentID as Name to that Image 

to your rootFolder say StudentImages. Now once u r trying to Display the Photo Of the student 

then try to get the Same id Photo from the Root\StudentImages folder and Pass This Image path to your Image Control in your Form. and u will successfully display the image of the Student.

Please Mark As Answered, If u find this is the Solution of your Post

Answer 4

User1216460367 posted

hi,

Ok...I have:

table with the name: patiendimages in a DataBase with the name: EMR... in access.

the patiendimages table have the following fields:

id = autonumber

med_rec_num = number

image - OLE

 

now what? ... Im linking the image field with the folder where I have the image, but nothing happens...only show

a square with a red X.

 

Thanks,

 

Answer 5

User-1199946673 posted

the patiendimages table have the following fields:

id = autonumber

med_rec_num = number

image - OLE

 

Unless you're only using images of the same filetype, it is better to store at least the MimeType as well. Nad you nee a Http Handles to retrieve the image from the database and show it. Everything is explained in the link I posted before. Did you read the article?

Answer 6

User1216460367 posted

yes, but I dont now how or where use the code

tks...

 

Im trying to show 1 image in a foamview template... 

Answer 7

User-1199946673 posted

yes, but I dont now how or where use the code

tks...

 

Im trying to show 1 image in a foamview template... 

 

In that case I think you should take another approach. Save the image in the filesystem, in the database your store the path to the image.

Answer 8

User1216460367 posted

I did it and this what it shows... 

 

 

Answer 9

User-1199946673 posted

I did it

 

It would help if you would shows us (code) what you did? Then we could try to find where you go wrong?

Answer 10

User1216460367 posted

Hi, this is the code:

The photo is in this path:

G:\COIS 450\COIS 450 FP\images\PatientImages\1.bmp

 

<

asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False" DataSourceID="AccessDataSource2"

 

Height="50px" Width="288px" CellPadding="4" ForeColor="#333333" GridLines="None">

 

<Fields>

 

 

<asp:BoundField DataField="first_name" HeaderText="first_name" SortExpression="first_name" />

 

 

<asp:BoundField DataField="lastP_name" HeaderText="lastP_name" SortExpression="lastP_name" />

 

 

<asp:BoundField DataField="lastM_name" SortExpression="lastM_name" HeaderText="lastM_name" />

 

 

<asp:BoundField DataField="dob" HeaderText="DoB" SortExpression="dob" DataFormatString="{0:d}" />

 

<asp:BoundField DataField="sex" HeaderText="sex" SortExpression="sex" />

 

<asp:ImageField DataImageUrlField="patient_photo" ReadOnly="True">

 

</asp:ImageField>

 

</Fields>

 

<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />

 

<CommandRowStyle BackColor="#D1DDF1" Font-Bold="True" />

 

<RowStyle BackColor="#EFF3FB" />

 

<FieldHeaderStyle BackColor="#DEE8F5" Font-Bold="True" />

 

<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />

 

<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />

 

<EditRowStyle BackColor="#2461BF" />

 

<AlternatingRowStyle BackColor="White" />

 

</asp:DetailsView>

Answer 11

User-1199946673 posted

The photo is in this path:

G:\COIS 450\COIS 450 FP\images\PatientImages\1.bmp

 

Instead of saving the full path, you need to store the relative path to the root of your website! Something like:

~\images\PatientImages\1.bmp