How Do I Upload A File From My Aspx Page To A Database

Question

0.00/5 (No votes)

See more:

i used this code to upload the file to my page

C#

protected void upload_Click(object sender, EventArgs e)
        {
            if (FileUpload1.HasFile)
            {
                string fileName = FileUpload2.FileName;
                string path = Path.GetFullPath(FileUpload2.FileName);
                TextBox2.Text = fileName;
                FileUpload2.SaveAs(Server.MapPath(fileName));
                passport1img.ImageUrl = path;
            }
        }

but i receive this error when i click to upload to the database

(Message)MySqlException: Could not find file 'C:\Program Files (x86)\Common Files\Microsoft Shared\DevServer\10.0\mfb1.jpg'.
(Source)MySqlException: mscorlib
(StackTrace)MySqlException at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access) at SchoolManagementSystem.schlreg.processreg_Click(Object sender, EventArgs e) in C:\Users\israel asha\documents\visual studio 2010\Projects\SchoolManagementSystem\SchoolManagementSystem\schlreg.aspx.cs:line 113

and i used this to convert it into binary format for upload into the database

byte[] passport2 = null;
FileStream fs2 = new FileStream(TextBox2.Text, FileMode.Open, FileAccess.Read);
BinaryReader br2 = new BinaryReader(fs2);
passport2 = br2.ReadBytes((int)fs2.Length); // int here is to cast d image into whole numbers

line 113 being this line

ASM

byte[] passport2 = null;
                FileStream fs2 = new FileStream(TextBox2.Text, FileMode.Open, FileAccess.Read);

Thanks for your usual assistance

Posted 6-Oct-14 7:47am

EasyHero

Add a Solution

2 solutions

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)

Afzaal Ahmad Zeeshan · Answer 1 · 2014-10-06T08:33:00

The error that you've shown us is enough to elaborate the problem that the file you're trying to pass to the FileStream is not found.

Could not find file 'C:\Program Files (x86)\Common Files\Microsoft Shared\DevServer\10.0\mfb1.jpg'.

It shows, that the file was not found at that location. Make sure the file exists, I believe it is some sort of dependency file (but a .jpg file? Microsoft, you sure?).

Richard Deeming · Answer 2 · 2014-10-06T08:30:00

The FileName property returns either the name of the file, or the path of the file on the client, depending on the browser settings. In this case, it looks like you're getting just the name.

Path.GetFullPath will resolve the path of the file relative to the current path. In this case, the current path is the folder containing the Visual Studio development server.

Server.MapPath will resolve the path relative to the currently executing page. This is not necessarily the same as the current path used by GetFullPath.

You need to save the file in a known location, to which your site must have write access. For example, if you want to save the file in a folder called images in the root of your site:

C#

protected void upload_Click(object sender, EventArgs e)
{
    if (FileUpload1.HasFile)
    {
        string fileName = Path.GetFileName(FileUpload1.FileName);
        string virtualPath = "~/images/" + fileName;
        string physicalPath = Server.MapPath(virtualPath);
        FileUpload1.SaveAs(physicalPath);
        passport1img.ImageUrl = virtualPath;
        
        SaveToDatabase(physicalPath);
    }
}

private void SaveToDatabase(string pathToImageFile)
{
    byte[] fileBytes = File.ReadAllBytes(pathToImageFile);
    ...
}

Alternatively, you could skip saving the file to disk, and save it directly to the database:

C#

protected void upload_Click(object sender, EventArgs e)
{
    if (FileUpload1.HasFile)
    {
        int length = (int)FileUpload1.FileContent.Length;
        byte[] fileBytes = new byte[length];
        FileUpload1.FileContent.Read(fileBytes, 0, length);
        
        SaveToDatabase(fileBytes);
    }
}

private void SaveToDatabase(byte[] fileBytes)
{
    ...
}

How Do I Upload A File From My Aspx Page To A Database

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0