How to store image in Sql Server Database using C# ?

Question

Dear All

I am try to convert image in byte then insert it into Database using C#.Below is my code .........

public byte[] getImageData(string strFleNm)

{

byte[] ImgData = null;

FileInfo fileinfo = new FileInfo(strFleNm);

long imagefilelenght = strFleNm.Length;

FileStream Fs = new FileStream(strFleNm, FileMode.Open, FileAccess.Read);

BinaryReader Br = new BinaryReader(Fs);

ImgData = Br.ReadBytes((int)imagefilelenght);

return ImgData;

}

but its give error,Error is like Could not find image .....................

Sunny Sharma · Answer

Hi Prafulla I think the error lies somewhere out of this code section. In this code snippet there's no mention of an Image type so how could it generate an error like-couldn't find image? ----------------------------- public byte[] getImageData(string strFleNm) { byte[] ImgData = null; FileInfo fileinfo = new FileInfo(strFleNm); long imagefilelenght = strFleNm.Length; FileStream Fs = new FileStream(strFleNm FileMode.Open FileAccess.Read); BinaryReader Br = new BinaryReader(Fs); ImgData = Br.ReadBytes((int)imagefilelenght); return ImgData; } ---------------------------------------- I suggest you use breakpoint in your codes and check what line or lines of code is causing the problem. Happy Coding :)

Iftikar Hussain · Answer

you might have passing wrong file path Regards Iftikar

Iftikar Hussain · Answer

are you uploading the image file and then try to save it or how? Regards Iftikar

Sanjeeb Lenka · Answer

check this link. http://www.c-sharpcorner.com/uploadfile/gowth/save-and-retrieve-image-from-sql-2005-in-Asp-Net/ if any doubt plz share your full cs code

Iftikar Hussain · Answer

Hi Are you trying to store the image or just image file in DB? Regards Iftikar