Im currently working on an image oriented system. Im having problems on how to save and retrieve it. My question is, is it possible to save the image path on your sql table then retrieve it based on an ID# entered in a textbox. What data type should i use in the sql server? and is it just the same as saving a data in saving an image path so I could retrieve it later? I only know how to upload an image but i find very tricky saving and retrieving it. anyway here's my code in uploading image.
Thanks in advance! cheers!
Private Sub cmdUpload_Click() Dim i As String On Error GoTo ErrorHandler With objCD 'objCD common dialog .CancelError = True .DialogTitle = "Open Image" .Filter = "Images|*.gif;*.jpg;*.jpeg;*.png;*.bmp;*.raw;*.rle|All Files|*.*" .ShowOpen Picture1.Picture = LoadPicture(.FileName) End With ErrorHandler: End Sub