download a file what i have previously uploaded

See more:

ASP.NET

Hello

I want to download a file what i have previously uploaded.

I have an asp.net application that contain.

One textbox for id and one fileupload control for upload document and one button for upload document.

I am created a database
Eid integer primary key
EFilename nvarchar(100)

Then i write coding for upload the file in button_click.

using System.Data.SqlClient
 SqlConnection con;
        con = new SqlConnection("Server=DELL\\SQLEXPRESS;database=Student;integrated security=true");
        con.Open();
        string ph = "~/Upload/" + FileUpload1.FileName;
        FileUpload1.SaveAs(MapPath(ph));
        string str = "insert into upload values('" + TextBox1.Text + "','" + ph + "')";
        SqlCommand cmd = new SqlCommand(str, con);
        cmd.ExecuteNonQuery();
        Response.Write("Value inserted");
        con.Close();

Then the value will be stored in data base.

Now i want download a file what i have uploaded into database.

Now i take another web form that contain one dropdownlist i bind dropdownlist with database (Efilename column of already eisting table in database)
and take one button for download
and write the following code.

string fname = DropDownList1.SelectedItem.Text;
string filepath = Server.MapPath(".\\Uploads\\" + fname);
FileInfo fi = new FileInfo(filepath);
if (fi.Exists)
{   Response.ClearContent();
        Response.AddHeader("Content-Disposition", "attachment;filename=" + fname);
        Response.AddHeader("Content-Length", fi.Length.ToString());
        Response.ContentType = "application";
        Response.TransmitFile(fi.FullName);
        Response.End();
    }

When i execute there no result.

Give u R Answer.