Click here to Skip to main content
15,891,248 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
i want to upload multiple images in multiple column in database . i tried but i can upload multiple images in one column.. not in multiple column like i have to upload 10 image in 10 column.. all images shuolud be selected at one time.

plzz show me way.
Posted

1 solution

The mechanism to load an image to one column or 10 columns is the same, you insert a row into the database and provide the bytes for the image as the value to insert. The difference is that you have either 1 picture column or 10 columns in the insert statement.

I would advice you to use a single column and instead of adding one row with 10 images you should add 10 rows with one image. Also I'd suggest using a filestream for the task. Have a look at How to store and fetch binary data into a file stream column[^]
 
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