asked on 2/24/2007

URI formats are not supported - trying get get an image thats held in a SQL field

Hi there

Wonder if you can help me?

I'm using C#, and want to send an email out to users using SMTP, the data will come from SQL, and images will be uploaded to a SQL table. When the email is sent to the users it must contain the data from SQL table, but also, it must display the image in the email (as I said, the image is held in a SQL table - image field in SQL)

The problem I'm having is on this line in my SMTP code

LinkedResource logo = new LinkedResource(<ERROR>);

"URI formats are not supported."

How do I display an image, thats stored in a SQL image field. Please note, I cant upload the file to the server.

Thanks
Mousemat24

.NET Programming

Last Comment

Die-Tech

3/1/2007

ASKER CERTIFIED SOLUTION

Die-Tech

2/28/2007

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

mousemat24

3/1/2007

ASKER

Thanks Die-Tech

Ok, so if I have an image on my c:\ i.e.

c:\logo.jpg

What would my code be to get it streamed across?

Thanks

mousemat24

3/1/2007

ASKER

sorry that was a bad example i.e. c:\logo.jpg

I mean if i get the image, how would i place that as a stream?

Die-Tech

3/1/2007

You could use a FileStream in that case; however, the LinkedResource class has a constructor that accepts the file name. All it does internally is create a stream that it passes to the other constructor, but it's one less step you have to do.

string fileName = @"c:\logo.jpg";
LinkedResource logo = new LinkedResource(fileName);