471,327 Members | 2,595 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,327 software developers and data experts.

Downloading Zip from SQL Image field

I'm converting a Delphi app to C#. The application uploads and downloads
files to an image field on SQL through a webservice. With Delphi, this was
done straight to SQL instead of a webservice. The C# code works fine in both
directions except in the case of zip files. I get a message, from WinZip,
telling me that the archive is not valid. The zip is valid, in the sql
server, becuase it can be opened when using my old Delphi version of this
program. I can also upload the zips with the C# version and open them with
the Delphi version so I'm pretty sure it how the file is being re-created
using C#.

Below is the code that I use to download and open the file Any help would be
appreciated.

TIA

//Get the document from the table
DataRow rowDataImage = null;
DataRowView rowData =
DataRowView)BindingContext[dsLibrary.Tables["AvailDocs"]].Current;
DataSet ds = DB.getDoc(System.Convert.ToInt32(rowData[0].ToString()));
string strDocExt =
DB.getDocFileExt(System.Convert.ToInt32(rowData[0].ToString()));
rowDataImage=ds.Tables[0].Rows[0];

//Read the image from the table field into a byte array
byte[] MyData= new byte[0];
MyData = (byte[])rowDataImage[0];
int ArraySize = new int();
ArraySize = MyData.GetUpperBound(0);

//Create a destination for the file
FileStream fs = new FileStream("c:\\elibtemp." + strDocExt,
FileMode.Create,FileAccess.Write,FileShare.Write,A rraySize,true);

// Create the writer for data.
fs.Write(MyData, 0,ArraySize);
fs.Close();
Dec 23 '05 #1
1 1565
Hi,

No idea if this is related or not, but in my office computer I have a
similar error, each time I select to download something from the internet
and select "open" instead of "save" I get the same error, but if I save it
first and open later I have no problem at all. I had no time to investigate
why is this happening, maybe the antivirus or a security policy.

Btw, the code seems fine , you did not post it how you are getting it from
the DB but it should be fine too.

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"jo**@nospam.com" <jo**@nospam.com@discussions.microsoft.com> wrote in
message news:21**********************************@microsof t.com...
I'm converting a Delphi app to C#. The application uploads and downloads
files to an image field on SQL through a webservice. With Delphi, this was
done straight to SQL instead of a webservice. The C# code works fine in
both
directions except in the case of zip files. I get a message, from WinZip,
telling me that the archive is not valid. The zip is valid, in the sql
server, becuase it can be opened when using my old Delphi version of this
program. I can also upload the zips with the C# version and open them with
the Delphi version so I'm pretty sure it how the file is being re-created
using C#.

Below is the code that I use to download and open the file Any help would
be
appreciated.

TIA

//Get the document from the table
DataRow rowDataImage = null;
DataRowView rowData =
DataRowView)BindingContext[dsLibrary.Tables["AvailDocs"]].Current;
DataSet ds = DB.getDoc(System.Convert.ToInt32(rowData[0].ToString()));
string strDocExt =
DB.getDocFileExt(System.Convert.ToInt32(rowData[0].ToString()));
rowDataImage=ds.Tables[0].Rows[0];

//Read the image from the table field into a byte array
byte[] MyData= new byte[0];
MyData = (byte[])rowDataImage[0];
int ArraySize = new int();
ArraySize = MyData.GetUpperBound(0);

//Create a destination for the file
FileStream fs = new FileStream("c:\\elibtemp." + strDocExt,
FileMode.Create,FileAccess.Write,FileShare.Write,A rraySize,true);

// Create the writer for data.
fs.Write(MyData, 0,ArraySize);
fs.Close();

Dec 27 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

23 posts views Thread by Doug van Vianen | last post: by
archulu
2 posts views Thread by archulu | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.