Storing and retreiving for files into and out to a Database

Question

0.00/5 (No votes)

See more:

Hallo Guys,

I want to build an app that stores for word document, pdf and other documents into a database. I don't want to save its path instead. When the doc is required, first I want to pull off it from the database and then save it into disk.

Does storing the doc file into a database brings a format change into the doc itself?

Thanks

Posted 20-May-13 5:29am

Yonathan1111

Updated 17-Jul-13 23:15pm

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2013-05-20T05:32:00

Solution 1

No, provided you save it the right way.
If you use a binary column, and pass the document as a parameter (rather than trying to concatenate it into the command string) then it should work fine. (A VARCHAR column may work, but a binary could be smaller, and may prevent some conversion errors if you don;t know what the file type contains)

Posted 20-May-13 5:32am

OriginalGriff

Comments

Yonathan1111 20-May-13 12:53pm

Thanks,
Here is my attempt, but it did not work out.

string ext = Path.GetExtension(@_path);
FileSecurity fSecurity = File.GetAccessControl(_path);

fSecurity.AddAccessRule(new FileSystemAccessRule(Environment.UserName,
FileSystemRights.WriteData, AccessControlType.Allow));

// Set the new access settings.

File.SetAccessControl(_path, fSecurity);

string file = String.Empty;

using (StreamReader sr = new StreamReader(File.Open(@_path, FileMode.Open)))
{
file = sr.ReadToEnd();

using (StreamWriter sw =
new StreamWriter(File.Create(@"Test.doc")))
{
sw.Write(file);
}
}
}
catch (Exception)
{

}

OriginalGriff 20-May-13 13:20pm

"it did not work out" is not very helpful - you need to stop swallowing exceptions and report them so you can see what is going wrong. Without the error, it is next to impossible to fix! :laugh:

Why are you reading with a Stream reader?
Try this:
byte[] data = File.ReadAllBytes(_path);
File.WriteAllBytes("Test.doc", data);
but give Test.Doc a path so it goes into a known folder rather the "current folder" which may not have sufficient access (it is the App folder by default).
And stop swollowing exceptions!
catch(Exception ex)
{
Console.Write(ex.ToString());
}
will at least tell you what the system s complaining about.

Yonathan1111 21-May-13 8:16am

Hi, Thanks a Lot.

It worked.

OriginalGriff 21-May-13 8:22am

You're welcome!