Multi-attachment upload form, what should I do when downloading?

saxonn

My database field "multiple attachment upload address" has the form:
A: / aaa; B: / bbb; C: / ccc;
What to do when downloading?

 public string FormatString (string str)
    {
        str = str.Replace ("", "" ";;
        str = str.Replace ("<", "<");
        str = str.Replace (">", ">");
        str = str.Replace ('\n'.ToString (), "<br>");
        return str;
    }
    protected void Button1_Click (object sender, EventArgs e)
    {
        if (Request ["id"]! = null)
        {
            int id = Convert.ToInt32 (Request ["id"]); // Convert to a number to prevent SQL injection

            SqlConnection conn = new SqlConnection (ConfigurationManager.ConnectionStrings ["SQLCONNECTIONSTRING"]. ConnectionString);
            conn.Open ();
            adr = "select attachment upload address from Mail WHERE mail number =" + id;
            SqlCommand cmd = new SqlCommand (adr, conn);
            string path = cmd.ExecuteScalar (). ToString ();
            // Get the path
            filepath = FormatString (path.ToString ()). ToString (). Trim ();

            string Temp_filename = FormatString (path.ToString ()). ToString ();
            int pos = Temp_filename.LastIndexOf ("\\") + 1;
            filename = Temp_filename.Substring (pos, Temp_filename.Length-pos) .ToString ();
            filename = HttpUtility.UrlEncode (System.Text.Encoding.UTF8.GetBytes (filename));

            Response.Clear ();
            Response.ClearHeaders ();
            Response.ClearContent ();
            FileStream fs = new FileStream (filepath, FileMode.Open);
            long FileSize = fs.Length;
            byte [] Buffer = new byte [(int) FileSize];
            fs.Read (Buffer, 0, (int) fs.Length);
            fs.Close ();
            Response.ContentType = "application / octe-stream";
            Response.AddHeader ("content-disposition", "attachment; filename =" + filename);
            Response.Charset = "UTF-8";
            Response.ContentEncoding = System.Text.Encoding.UTF8;
            Response.BinaryWrite (Buffer);
            conn.Close ();
        }
    }

I can only download a single attachment in the form of: A: / aaa, how can I change it?
Thanks to the respondent ~~

寒雪鸣

A:/aaa;B:/bbb;C:/ccc
Cut into an array and make a loop

crabhero

You can list the files to be downloaded, and then the user chooses to download, or open a window for each attachment to download, but this seems to be a bad user experience

saxonn

crabhero


   
For example: When I upload 3 files at a time, 3 rows of records are generated in the database:
A:/aaa;
A:/aaa;B:/bbb;
A:/aaa;B:/bbb;C:/ccc;
What I want is to generate only one row of records in the database for each upload, such as:
A:/aaa;B:/bbb;C:/ccc;
------------------------------------
The record you inserted into the database when you traversed to the last attachment is correct. Presumably you made the insertion inside the loop. In fact, you only need to construct the path string (A:/aaa;B:/bbb;C:/ccc; ) Insert just outside the loop, you can look at the code of your database operation

This is your answer to the "multiple attachment upload question" just now,
Thank you very much, now this download is difficult, please help me again

pyonus

Define a string array, and then store the path into the array, such as:

filepath=filepath.Substring(0,filepath.Length-1)//Remove the last semicolon
string[] strpaths = filepath.Split(';');//Remove the path between semicolons and put them in the array

Then use a loop output.

caix001

string path="A:/aaa;B:/bbb;C:/ccc";
string s=";"
char[] p=s.ToCharArray();
string b[]=path.Split(p);
for(int i=0;i<b.length;i++)
{
    Insert statement what insert into A values(b[i].Tostring());
}

crabhero

You can refer to the practice of most mail systems, when you receive an email with multiple attachments
The system creates a hyperlink for each attachment, and the user clicks to download the corresponding item instead of only providing a "download all" button
Download all attachments in one brain. An html page, only downloading a single file after specifying the contenttype. If you want to provide multiple attachments at once, you need to open multiple windows. It is not recommended to do this. If you need to do this, you can output the path combination to the page. Open a new window with javascript, and then pass the path to the new window one by one to download.

adahg30

List the files to let the user choose, and it is not good to download all of them after clicking a link!
Otherwise, pack it all, and download the next compressed package afterwards!

burtmao

string aaa = "A:/aaa;B:/bbb;C:/ccc";
Cut into an array and make a loop
string [] strAddress = aaa.slipt(";");

sukdevils

Seriously agree with the method upstairs, requiring the length of the lower cut array, you can do a loop