Solved

MULTI FILE UPLOAD

Posted on 2013-11-10
6
99 Views
Last Modified: 2014-10-01
Please find the attached C# code as a reference.   The Upload function is working for "fileUpload1"; however, not for "fileUpload2" .   When I submit with "fileUpload2" containing the file only #1 goes into the data base.    


protected void btnSubmit_Click(object sender, EventArgs e)
    {
        if (fileUpload1.HasFile)
        {
           
            fname = fileUpload1.FileName;
            spath = @"~\Uploaded\" + fileUpload1.FileName;
            fpath = Server.MapPath("~/Uploaded");
            fpath = fpath + @"\" + fileUpload1.FileName;            
            txtSubject1 = txtSubject.Text;
            Ship1 = Ship.Text;
            Sta1 = Sta.Text;
             
            if (System.IO.File.Exists(fpath))
            {
                Label1.Text = "File Name already exists!";
                return;
            }
            else
            {
                fileUpload1.SaveAs(fpath);
            }
            //Store details in the SQL Server table
            StoreDetails();
            txtSubject.Text = "";
            Ship.Text = "";
            Sta.Text = "";
            
        }
        else
        {
            Label1.Text="Please select file!";
        }


        if (fileUpload2.HasFile)
        {

            fname = fileUpload2.FileName;
            spath = @"~\Uploaded\" + fileUpload2.FileName;
            fpath = Server.MapPath("~/Uploaded");
            fpath = fpath + @"\" + fileUpload2.FileName;
            txtSubject1 = txtSubject.Text;
            Ship1 = Ship.Text;
            Sta1 = Sta.Text;

            if (System.IO.File.Exists(fpath))
            {
                Label1.Text = "File Name already exists!";
                return;
            }
            else
            {
                fileUpload2.SaveAs(fpath);
            }
            //Store details in the SQL Server table
            StoreDetails();
            txtSubject.Text = "";
            Ship.Text = "";
            Sta.Text = "";

        }
        else
        {
            Label2.Text = "Please select file!";
        }


    }
    void StoreDetails()
 {
     String query;
     query = "insert into fileDet(fname,fpath,desc1,Ship,Sta,Dates) values('" + fname + "','" + spath + "','" + txtSubject1 + "','" + Ship1 + "','" + Sta1 + "','" + DateTime.Now + "')";
     sqlcon.Open();
     sqlcmd = new SqlCommand(query, sqlcon);
     sqlcmd.CommandType = CommandType.Text;
     sqlcmd.ExecuteNonQuery();
     sqlcon.Close();

Open in new window

protected void btnSubmit_Click(object sender, EventArgs e)
    {
        if (fileUpload1.HasFile)
        {
           
            fname = fileUpload1.FileName;
            spath = @"~\Uploaded\" + fileUpload1.FileName;
            fpath = Server.MapPath("~/Uploaded");
            fpath = fpath + @"\" + fileUpload1.FileName;            
            txtSubject1 = txtSubject.Text;
            Ship1 = Ship.Text;
            Sta1 = Sta.Text;
             
            if (System.IO.File.Exists(fpath))
            {
                Label1.Text = "File Name already exists!";
                return;
            }
            else
            {
                fileUpload1.SaveAs(fpath);
            }
            //Store details in the SQL Server table
            StoreDetails();
            txtSubject.Text = "";
            Ship.Text = "";
            Sta.Text = "";
           
        }
        else
        {
            Label1.Text="Please select file!";
        }


        if (fileUpload2.HasFile)
        {

            fname = fileUpload2.FileName;
            spath = @"~\Uploaded\" + fileUpload2.FileName;
            fpath = Server.MapPath("~/Uploaded");
            fpath = fpath + @"\" + fileUpload2.FileName;
            txtSubject1 = txtSubject.Text;
            Ship1 = Ship.Text;
            Sta1 = Sta.Text;

            if (System.IO.File.Exists(fpath))
            {
                Label1.Text = "File Name already exists!";
                return;
            }
            else
            {
                fileUpload2.SaveAs(fpath);
            }
            //Store details in the SQL Server table
            StoreDetails();
            txtSubject.Text = "";
            Ship.Text = "";
            Sta.Text = "";

        }
        else
        {
            Label2.Text = "Please select file!";
        }


    }
    void StoreDetails()
 {
     String query;
     query = "insert into fileDet(fname,fpath,desc1,Ship,Sta,Dates) values('" + fname + "','" + spath + "','" + txtSubject1 + "','" + Ship1 + "','" + Sta1 + "','" + DateTime.Now + "')";
     sqlcon.Open();
     sqlcmd = new SqlCommand(query, sqlcon);
     sqlcmd.CommandType = CommandType.Text;
     sqlcmd.ExecuteNonQuery();
     sqlcon.Close();
0
Comment
Question by:BOEING39
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
6 Comments
 
LVL 29

Expert Comment

by:Paul Jackson
ID: 39637716
Have you tried stepping through the code to see when/if an error occurs?

Are any of your database fields mandatory as you are setting several field to empty string after calling StoreDetails() for the first upload file :

txtSubject.Text = "";
            Ship.Text = "";
            Sta.Text = "";

so maybe you are getting an error when you call StoreDetails() for the 2nd file upload because these fields are blank.
0
 

Author Comment

by:BOEING39
ID: 39637753
When I attach a file to fleUpload1 the attached file is Uploaded to the "Uploads" folder along with the corresponding text being entered into the respective data base.  

When I attach a file to "fileUpload2" the same text information should go to the data base and the fileUpload2 attachment should be sent to the Uploads folder.  This is not occurring.
0
 

Accepted Solution

by:
BOEING39 earned 0 total points
ID: 39679662
No responses further responses.  Please close question.
0
 

Author Closing Comment

by:BOEING39
ID: 40354158
Lack of response.
0

Featured Post

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Whether you’re a college noob or a soon-to-be pro, these tips are sure to help you in your journey to becoming a programming ninja and stand out from the crowd.
This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
The viewer will learn how to implement Singleton Design Pattern in Java.
The goal of the video will be to teach the user the difference and consequence of passing data by value vs passing data by reference in C++. An example of passing data by value as well as an example of passing data by reference will be be given. Bot…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question