ahmed elbarbary

ahmed elbarbary

  • 636
  • 1.6k
  • 282.1k

How to convert images jpg from path to varbinary(MAX) in dat

Jun 23 2019 4:41 AM

Problem

How to convert images jpg from path to varbinary(MAX) in databaseon csharp windows form visualstudio 2015 ?

Details

I have Table ImagesData have two fields

SpecialCode nvarchar(20)

imagebinary varbinary(max)

I need to update images from path D:/Images to ImagesData Table based on SpecialCode

to show more clear

1- in my hard disk i have drive D have Folder Images so that path will be D:/Images

2- In D:/Images Folder i have pictures JPG may be 100 images as following

images Names in D:/Images Path as following

0001-1

000002-5

00001-3

0004-2

008523-1

In my path ImagesData Table my data as follwoing

SpecialCode imageBinary

0001/1

000002/5

00001/3

0004/2

actually when images Name exist on image path D:/Images matches specialcode in table

update field imagebinary to binary by convert image on path D:/Images to binary then update it on field imagebinary when specialcode of image on path D:/images matches SpecialCode on table ImagesData

if not matches not update it .

Example

if((imagepath 0001-1 == 0001/1 from table imagesData)
{
update field imagebinaryon table imagesData by convert image to binary it because it matches
}
else
{
not update because it not matched
}

Can you help me please on that to summarize what i need

i need to update field as binary when matched specialcode on table to images name on path D:/Images


Answers (1)