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

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

/*
using System;
using System.Data.SqlClient;
using System.IO;
*/
var connectionString = ""; // unknown
using (var conn = new SqlConnection(connectionString))
{
try
{
conn.Open();
var cmd = conn.CreateCommand();
cmd.CommandText = "UPDATE ImagesData SET Imagebinary = @Imagebinary WHERE SpecialCode = @SpecialCode";
foreach (var fn in Directory.GetFiles(@"D:\Images", "*.jpg"))
{
var parts = Path.GetFileNameWithoutExtension(fn).Split('-', 2);
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("Imagebinary", File.ReadAllBytes(fn));
cmd.Parameters.AddWithValue("SpecialCode", parts[0] + "/" + parts[1]);
cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
if (conn.State != System.Data.ConnectionState.Closed)
{
conn.Close();
}
}
}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Mario Scheeren7y ago
/*
using System;
using System.Data.SqlClient;
using System.IO;
*/
var connectionString = ""; // unknown
using (var conn = new SqlConnection(connectionString))
{
    try
    {
        conn.Open();

        var cmd = conn.CreateCommand();
        cmd.CommandText = "UPDATE ImagesData SET Imagebinary = @Imagebinary WHERE SpecialCode = @SpecialCode";

        foreach (var fn in Directory.GetFiles(@"D:\Images", "*.jpg"))
        {
            var parts = Path.GetFileNameWithoutExtension(fn).Split('-', 2);
            cmd.Parameters.Clear();
            cmd.Parameters.AddWithValue("Imagebinary", File.ReadAllBytes(fn));
            cmd.Parameters.AddWithValue("SpecialCode", parts[0] + "/" + parts[1]);
            cmd.ExecuteNonQuery();
        }

    }
    catch (Exception ex)
    {
        Console.WriteLine(ex.Message);
    }
    finally
    {
        if (conn.State != System.Data.ConnectionState.Closed)
        {
            conn.Close();
        }
    }
}