Store Images as OLE Object in Access OLE Object Field using ADO in vb6
-
I am handling a large-scale project entitled as MIS (Marketing information System). I am using Vb 6 as front end, Ms Access as back end and Crystal report 8 as reporting tool. 1) In the project i am required to save customers image to database, and it should be shown in individual customer’s report, which will include that image. I had taken OLE field in the database to save images. I had taken Common dialog box control to select image and display it in OLE control, but i don't know how to save the OLE controls image to database. i am using ADO object to access the database. How could I can save and retrieve the image from database? Is it possible to save images by using other controls like Picture box or image control in the form? I want to save image as bitmap in the database. 2) The size of project is very large then it is useful to store image to database? Will it make it slower to access database? 3) Saving path of image in database will make any difference? If i do so then how can show the images in report (Crystal report 8)?
Kiran Sajanikar Software Engineer CleverBIT softwares. Pune.
-
I am handling a large-scale project entitled as MIS (Marketing information System). I am using Vb 6 as front end, Ms Access as back end and Crystal report 8 as reporting tool. 1) In the project i am required to save customers image to database, and it should be shown in individual customer’s report, which will include that image. I had taken OLE field in the database to save images. I had taken Common dialog box control to select image and display it in OLE control, but i don't know how to save the OLE controls image to database. i am using ADO object to access the database. How could I can save and retrieve the image from database? Is it possible to save images by using other controls like Picture box or image control in the form? I want to save image as bitmap in the database. 2) The size of project is very large then it is useful to store image to database? Will it make it slower to access database? 3) Saving path of image in database will make any difference? If i do so then how can show the images in report (Crystal report 8)?
Kiran Sajanikar Software Engineer CleverBIT softwares. Pune.
pls find this url http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvbpj01/html/gs0102.asp it's helpful for u
Parwej Ahamad