Captured image store into sql server in binary format

Bhavesh Vankar

hello I have try to convert captured image by webcam into binary format and want to save it in sql server nut its getting error like

"Additional information: Could not find a part of the path 'C:\VisiterManagment\VisiterManagment\CroppedImage\'."

below I tried code to convert image to binary.

public static byte[] ImageToBinary(string _imgpath)
{
FileStream fS = new FileStream(_imgpath, FileMode.Open, FileAccess.ReadWrite);
byte[] b = new byte[fS.Length];
fS.Read(b, 0, (int)fS.Length);
fS.Close();
return b;
}

kindly suggest me any idea.

9 Replies

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

Bhavesh Vankar5y ago
i am use web application so vImage.Image.Save(ms, ImageFormat.Jpeg);

image.save not working...
Rajanikant Hawaldar5y ago
try this working code.
byte[] buffer = File.ReadAllBytes("Path/to/your/image/");
SqlCommand command = new SqlCommand();
command.Text="INSERT INTO YOUR_TABLE_NAME (image) values (@image)";
command.Parameters.AddWithValue("@image",buffer);
command.ExecuteNonQuery();
or
set image to picturebox vImage then
//converting photo to binary data
if (vImage.Image != null)
{
       ms = new MemoryStream();
       vImage.Image.Save(ms, ImageFormat.Jpeg);
       byte[] photo_aray = new byte[ms.Length];
       ms.Position = 0;
       ms.Read(photo_aray, 0, photo_aray.Length);
       cmd.Parameters.AddWithValue("@photo", photo_aray);
}
Rajanikant Hawaldar5y ago
https://www.c-sharpcorner.com/blogs/image-conversion-and-storing-the-image-value-using-c-sharp
Bhavesh Vankar5y ago
i'm trying to save captured image by webcam and want to save it in sql server database in binary format.
Bhavesh Vankar5y ago
i have used method as per below.
public static byte[] ImageToBinary(string _imgpath)
{
FileStream fS = new FileStream(_imgpath, FileMode.Open, FileAccess.ReadWrite);
    byte[] b = new byte[fS.Length];
fS.Read(b, 0, (int)fS.Length);
fS.Close();
    return b;
}
and i have used this as per below in save button..
string filename = DateTime.Now.ToString("dd-MM-yy");
string _imgpath = Path.Combine(Server.MapPath("~/CroppedImage/"),filename);
vImage.ImageUrl = _imgpath;
cmd.Parameters.AddWithValue("@V_IMAGE", ImageToBinary( _imgpath));
but it still showing me error as per above..
Rajanikant Hawaldar5y ago
This _imgpath contains file or not? I think should be like for example Path.Combine(Server.MapPath("~/imagepath/"), fileName);
Bhavesh Vankar5y ago
my path is as below....
and this directory is available in my project but not working its showing me error as per above.
string _imgpath = Server.MapPath(@"~/CroppedImage/");
Rajanikant Hawaldar5y ago
Make sure the path you are trying to access is not present
Rajanikant Hawaldar5y ago
https://www.c-sharpcorner.com/UploadFile/e628d9/inserting-retrieving-images-from-sql-server-database-without-using-stored-procedures/