vales with images to store in db
hello ,,
In VB i am facing a problem that i have to input about 10000 questions in physics and maths & each Questions may contain any no. of images
and text as well.and it is possible using Rich Text box
but problem is that how to save these values in the Database.
can anyone suggest some other method or control for this problem
thanks
ankur bhatnagar
[401 byte] By [
ifw] at [2007-11-19 19:53:28]
# 1 Re: vales with images to store in db
If you have 10000 questions this can be a problem but yet you might be interested in the solution:
Build different folder for each question and name every file by a number without difference to different file type - you know that the first component get data from the first file (so you get the folder from the DB and orginaize the files in your form... of course you can optimize this method by merging answers buy some logic.
I know its mad so here is another idea
create a table for each number of images table one - for answers with one image ,table two... and so on. Create a main table to redirect an answer to the current table and you have a very bizarre efficient DB.
Last idea it is even a good one in some DB's I've worked with :
Concatenate the images names and store them in DB and than get then out by breaking the string:
dim strImages as string
strImages="img1.jpg*img2.gif*JPEGToBMP.doc*thatIsTheIdea.end"
Hope it helps
