Retrieve Image stored in SQL Server Table Column

[Guest]

How do you retrieve an image in ADO.NET stored in a SQL Server 2000 table column? In ADO I used a Stream object to retrieve the image and then there was a method in the Stream Object to save the image to a file. I used the following code in ADO for this

imgStream = New ADODB.Strea

With imgStrea
.Type = adTypeBinar
.Ope
.Write rsRecordset("ImageField").Valu
.SaveToFile strPictureFile, adSaveCreateOverWrit
.Clos
End Wit

Is there a ADO.NET equivalent?

 

[Miha Markic [MVP C#]]

Hi Angel,

Check these fine articles:
http://support.microsoft.com/search...L&maxResults=25&Titles=false&numDays=&InCC=on

--
Miha Markic [MVP C#] - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

How do you retrieve an image in ADO.NET stored in a SQL Server 2000 table

column? In ADO I used a Stream object to retrieve the image and then there
was a method in the Stream Object to save the image to a file. I used the
following code in ADO for this: