Getting binary image data from SQL Server

[NathanV]

I have a stored procedure that returns the binary representation of an image
from a SQL Server db. The following code returns an "Invalid parameter"
error on the System.Drawing... line. I am converting this code from Access.
Any ideas? Thanks!

byte[] imageData = (byte[])(command.ExecuteScalar());
MemoryStream ms = new MemoryStream(imageData);
System.Drawing.Image fullsizeImage = System.Drawing.Image.FromStream(ms);

[Martin Randall]

"NathanV" wrote:

I have a stored procedure that returns the binary representation of an image
from a SQL Server db. The following code returns an "Invalid parameter"
error on the System.Drawing... line. I am converting this code from Access.
Any ideas? Thanks!

byte[] imageData = (byte[])(command.ExecuteScalar());
MemoryStream ms = new MemoryStream(imageData);
System.Drawing.Image fullsizeImage = System.Drawing.Image.FromStream(ms);

I don't believe that this is an appropriate use of ExecuteScale()... try
using ExecuteReader( CommandBehaviour.SingleResult) and then use the
GetBytes() member of the resulting DataReader instance.

Hope that helps,

Martin