Retrieve image of greater than 1mb from sql server using c#

I want to retrieve images of greater than 1 mb in size from sql server in windpws application using c#.

When I try to insert the image of greater than 1 mb in size, it is inserted, but when I try to retrieve the image the runtime error is occurring i.e. "Parameter is not valid".

The code I tried to retrieve the image is :-

name = cbCust_Name.SelectedValue.ToString();
//btnDisplay_Click(sender, e);
SqlConnection cnn = new SqlConnection(conString);
MemoryStream stream = new MemoryStream();
cnn.Open();
SqlCommand command = new SqlCommand("Select Cust_Image from Photo where Cust_Name= '" + name + "'", cnn);
byte[] image = (byte[])command.ExecuteScalar();
stream.Write(image, 0, image.Length);
//cnn.Close();
Bitmap bitmap = new Bitmap(stream);
pictureBox1.Image = bitmap;

How can I retrieve the image of bigger size i.e. greater than 1 mb in size.

Thanks in Advance ...!!!

1 Reply

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

Raja T10y ago
Hello Ankush, Please check ur select query. And also Please check folder access rights available or not.You have to grant permission to the folder you are trying to access through your web application

more detail check below links for retrieve image from server

http://www.c-sharpcorner.com/uploadfile/e628d9/inserting-retrieving-images-from-sql-server-database-without-using-stored-procedures/

http://stackoverflow.com/questions/2175209/retrieve-images-from-sql-server-database
0