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

Prafulla Choudhary

13y2k.NET

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 .....................

5 Replies

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

Sunny Sharma13y ago
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 Hussain13y ago
you might have passing wrong file path

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

Regards,
Iftikar
Sanjeeb Lenka13y ago
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 Hussain13y ago
Hi,
Are you trying to store the image or just image file in DB?

Regards,
Iftikar