How to save & retrieve photos in a database

[Arun Hegde]

JOY Hai,:laugh: I am working on a student database project in Vb.net. I have established a connection betwen Ms-Access table & my form through DATASET. Now i am able to save & retrive the records. what i want is to store the photograph of students. if i am not wrong, we can use imagelist so that the photos can be displayed.but how to connect it from the access table . My second question is to know how to store & retrive the photos.so that whenever i move to a particular student's record ,his photo should appear.Can u pl help me with an example for a clear understanding if photos cannot be stored in a databae then what could be an alternative to this. pl exlain briefly if so. Arun :)

[kayos592]

In the past I would usually store the image NAME (ie. in a "Image_PathFileName" field. This way when I run through my recordsets I can retrieve the image by pulling the Image_PathFileName value and plugging it into my code..... -Kay

[Vasudevan Deepak Kumar]

Arun, You can store images in MsAccess. I think you can use Ole Object datatype for that. If you check out ASp.net website TimeTracker starterkit using Microsoft Access, you can see this implementation. Vasudevan Deepak Kumar Personal Web: http://www.lavanyadeepak.tk/ I Blog At: http://www.dotnetjunkies.com/weblog/deepak/
http://deepakvasudevan.blogspot.com/
http://deepak.blogdrive.com/

[Madni Abbasi]

You can use as folllowing 1- get the path using Open file dialogue in text box as I taken in txtCompanyLogo.text 2- Dim arr() As Byte If Trim(txtCompanyLogo.Text) <> "" Then FileOpen(1, txtCompanyLogo.Text, OpenMode.Binary, OpenAccess.Read, OpenShare.Shared) 'Resize array so that it can accomodate the file ReDim arr(FileLen(txtCompanyLogo.Text) - 1) FileGet(1, arr) FileClose(1) '/////// Ds is DataSet & CompanyInfo is TableName & CompanyLogo is Field Name for Binary Data //////////// ds.Tables("CompanyInfo").Rows(0).Item("CompanyLogo") = arr End If Enjoy Solution