asked on

Read an Image field from database using stored procedure

Hi you experts.

Is there a way to read an image field from an sql database using a stored procedure?
My problem is that all values in the rows tha are returned by the stored procedure are objects and can only be converted to string.I want to be able to take the Photo field that is being return by the stored procedure and asign it to a byte variable.

Any help will be very appreciated.

Thank you all in advance.

Bob Learned

1) .NET version?

2) Database type?

Bob

adktd

ASKER

VS.NET version 2003

Database Sql Server 2000(Unfortunatelly i preffer 2005 better)

Bob Learned

What do you mean by "all values in the rows that are returned by the stored procedure are objects"?

Bob

adktd

ASKER

For example : If an sp returns a dataset that has one table with a column named photo and a column named EmployeeName

string empName;
Byte empPhoto;

foreach(DataRow dr in myDataSet.Table[0].rows)
{
empname = dr["EmployeeName"].ToStirng();

dr["Photo"] -------------> is object
}

How can i assign dr["Photo"] to empPhoto ?

Bob Learned

dr["Photo"] should be a byte array.

byte[] data = dr["Photo"];

Bob

adktd

ASKER

When i try to complile i get the same error as i did before "Cannot implicitly convert type 'object' to 'byte[]'
byte[] data = dr["Photo"];

ASKER CERTIFIED SOLUTION

Bob Learned

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial