baec0a1f   
   XPost: microsoft.public.dotnet.languages.csharp   
   From: arne@vajhoej.dk   
      
   On 31-07-2010 20:36, Joe Cool wrote:   
   > On Jul 31, 8:29 pm, Joe Cool  wrote:   
   >> On Jul 31, 8:02 pm, Arne Vajhøj  wrote:   
   >>> On 31-07-2010 19:36, Joe Cool wrote:   
   >>>> I am cross posting this request for help in both the C#,NET and the   
   >>>> SQLServer newsgroups in he hope that some reader of one these   
   >>>> newsgroups can offer some help.   
   >>   
   >>>> I am well aware that the image datatype (as well as others) are being   
   >>>> phased out in some future version of SQL Server. For that reason, in   
   >>>> all of my personal C#.NET projects that store images use the   
   >>>> varbinary(max) datatype.   
   >>   
   >>>> I am in the process of converting a VB.NET project that I use for   
   >>>> consulting work with a former (and hopefully soon to be repeat)   
   >>>> employer tp C#.NET. When originally designed, their software was based   
   >>>> on SQL7. Currently their software supports SQL2005. One key table in   
   >>>> their database is a table of images and (not sure if it still does)   
   >>>> but legacy databases utilize the image datatype to store images. With   
   >>>> SQL7 I used a SQL command line utility called TEXTCOPY to extract the   
   >>>> binary content of image columns to a JPG file.   
   >>   
   >>>> This utility needs to be able to extract these images to external   
   >>>> files even for legacy databases that may still use the image datatype.   
   >>>> But I find that the technique I use to extract images from a   
   >>>> varbinary(max) column doesn't work for image datatypes. And I see that   
   >>>> SQL2005, while it still supports image datatype, the TEXTCOPY utility   
   >>>> is nowhere to be found.   
   >>   
   >>>> Any ideas on how to extract image data types from a SQL2005 database   
   >>>> with C#.NET?   
   >>   
   >>> Have you tried the obvious: SqlConnection, SqlCommand, SELECT,   
   >>> ExecuteReader, SqlDataReader og læse kolonnen som byte[] ?   
   >>   
   >> Here is what I am using that works with varbinary(max) datatype   
   >> columns.   
   >>   
   >> SqlCommand cmd;   
   >> SqlDataReader rdr;   
   >> DataTable dataTable;   
   >>   
   >> cmd = new SqlCommand("select imagecolumn, linkcolumn from images",   
   >> cn)'   
   >> rdr = cmd.ExecuteReader();   
   >> dataTable.Load(rdr);   
   >   
   > I should mention I write this out to an external JPG file by using a   
   > StreamWriter and casting column 0 of the datatable to a byte array.   
      
   StreamWriter is for text data.   
      
   Use a simple Stream/FileStream for binary data.   
      
   Arne   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)