Solved

MULTI FILE UPLOAD

Posted on 2013-11-10
6
94 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
  • 3
6 Comments
 
LVL 29

Expert Comment

by:Paul Jackson
Comment Utility
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
Comment Utility
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
Comment Utility
No responses further responses.  Please close question.
0
 

Author Closing Comment

by:BOEING39
Comment Utility
Lack of response.
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

This article is for Object-Oriented Programming (OOP) beginners. An Interface contains declarations of events, indexers, methods and/or properties. Any class which implements the Interface should provide the concrete implementation for each Inter…
Having just graduated from college and entered the workforce, I don’t find myself always using the tools and programs I grew accustomed to over the past four years. However, there is one program I continually find myself reverting back to…R.   So …
This tutorial explains how to use the VisualVM tool for the Java platform application. This video goes into detail on the Threads, Sampler, and Profiler tabs.
The goal of the video will be to teach the user the concept of local variables and scope. An example of a locally defined variable will be given as well as an explanation of what scope is in C++. The local variable and concept of scope will be relat…

772 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now