Click here to Skip to main content
15,883,809 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I wanna save picture in SQL Server 2000 through vb 6.0, kindly some one help me.
Posted

Storing image in the database will make your database bulky, instead you can store image in some pre-specified folder and store image name in the database.

-Amol
 
Share this answer
 
just i try to give some out line in vb.
first use some controls in forms Ex: picturebox,dirvelistbox,dirlistbox,filelistbox.

and use loadpicture in any sub procedure() ex:
dim filepath as string
FilePath = File1.Path &"\" &File1.FileName
Picture1.Picture = LoadPicture(File1.Path &"\" File1.FileName)
'-----end sub
in database create the following fields ex: filepathname,drivename,directory,filename.
and use save procedure()

rs("FilePathName") = Trim(FilePat)
rs("DriveName") = Trim(Drive1.Drive)
rs("Directory") = Trim(Dir1.Path)
rs("FileName") = Trim(FileNam)
rs.Update
end sub

thanking you
hop you understand or mailme karaikudiselvaraj.gmail.com i will give a sample project
 
Share this answer
 
v2
 
Share this answer
 
can any guide me how to code for saving link of folder in database?
 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900