Send and Retrieve files to Database

Hot Topic

[C#]conversion from time to double
reference object not updated
Is it possible to use a constant namespace wide?
How to get returned String Array from C++ based DLL while called in C#(P/Invoke related)?
How to make the application run for long time?
StopWatch
Include files in exe
Using a class as a parameter
Converting a string to a 64 bit WEP KEY
Special Keys (arrows) + multiple key press

Visual C#

Is there any tool functions as a switch in windows forms?
Asking for advice on abstraction choice...
Calling a c++ dll function in a C# thread
Listing files and folders, TreeView usage problem.
Embed Excel in WebBrowser on DotNet Form
How to store long value in byte array
IEnumerable issue
Copy class
Convert String to DateTime Object
Assign a LinearGradientBrush to the BackColor property of a UserControl ?

Send and Retrieve files to Database

hi again...

This time i'm stuck on an issue concerning sending and retrieving *.exe files to and from a SQL database.

Code to send:

FileStream fs = new FileStream(FileName, FileMode.Open, FileAccess.ReadWrite);

byte[] MyFile = new byte[fs.Length];

fs.Read(MyFile, 0, System.Convert.ToInt32(fs.Length));

fs.Close();

dAdapter = new SqlDataAdapter("Select * from system where id=1", cnn);

SqlCommandBuilder command = new SqlCommandBuilder(dAdapter);

DataSet ds = new DataSet("system");

dAdapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;

dAdapter.Fill(ds, "system");

DataRow row;

row = ds.Tables["system"].NewRow();

row["id"] = "1";

row["valuebin"] = MyFile;

ds.Tables["system"].Rows.InsertAt(row, 0);

dAdapter.Update(ds, "system");

Code to retrive:

byte[] MyFile = new byte[0];

string filename;

cnn.Open();

dAdapter = new SqlDataAdapter("Select * from system where id=1", cnn);

SqlCommandBuilder comm = new SqlCommandBuilder(dAdapter);

DataSet ds = new DataSet("system");

dAdapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;

dAdapter.Fill(ds, "system");

DataRow row;

row = ds.Tables["system"].Rows[0];

MyFile = (byte[])row["valuebin"];

filename = "MyFileName.exe";

int ArraySize = new int();

ArraySize = MyFile.GetUpperBound(0);

FileStream fs = new FileStream(Application.StartupPath + "\\" + filename, FileMode.OpenOrCreate, FileAccess.Write, FileShare.ReadWrite);

fs.Write(MyFile, 0, ArraySize);

fs.Close();

}

}

}

Well, the problem is that I can't use the file i've retrieved. I get "the file isn't a win32 valid application" when i try to run it.

I'm using this code to store and retrive other file types, but this only happens with *.exe's.

Any ideas on why this is happening

Thanks in advance.


Answer this question

Send and Retrieve files to Database

  • Jonathan Allen

    Thank you Markku

    Can you explain me why the method i used worked on files other than executable ones Should i always use the method you told me

    Thank you so much...



  • Alberto Acerbis

    found out that it as nothing to do with the database...

    tryed:

    FileStream fs = new FileStream(FileName, FileMode.Open, FileAccess.ReadWrite);

    byte[] MyFile = new byte[fs.Length];

    fs.Read(MyFile, 0, System.Convert.ToInt32(fs.Length));

    fs.Close();

    int ArraySize = new int();

    ArraySize = MyFile.GetUpperBound(0);

    string filen = "TryMe.exe";

    FileStream write = new FileStream(Application.StartupPath + "\\" + filen, FileMode.OpenOrCreate, FileAccess.Write, FileShare.ReadWrite);

    write.Write(MyFile, 0, ArraySize);

    write.Close();

    and TryMe.exe is not a valid win32 application

  • ultek

    Hi Pedro

    I'm not sure that it works OK on other files either. I testi it with text file and it lost last character.

    Actually reason of that erros is that GetUpperBound(0) give biggest index of array and size is 1 bigger than last index.

    Yours Markku

  • Webhostbudd

    Hi Pedro

    Change MyFile.GetUpperBound(0) to MyFile.Length and I think that file is valid.

    Yours

    Markku
  • Send and Retrieve files to Database
Answer this question