关于提问 | asp

本文介绍了关于提问的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

如何在asp.net的sqlserver数据库中上载和下载pdf文件?
谢谢.
D.K. Dixit

How to upload and download a pdf file in sqlserver database in asp.net?
Thanks.
D.K.Dixit

推荐答案

protected void btnSub_Click(object sender, EventArgs e)
    {
        try
        {
            string filename = FileUpload1.FileName;
            string filename1 = FileUpload2.FileName;
            FileUpload1.PostedFile.SaveAs(Server.MapPath("~\\Uploadform\\" + filename.Trim()));
            FileUpload2.PostedFile.SaveAs(Server.MapPath("~\\Uploadform\\" + filename1.Trim()));
            string path = "~\\Uploadform\\" + filename.Trim();
            string path1 = "~\\Uploadform\\" + filename1.Trim();
            SqlConnection con = new SqlConnection(str);
            cmd = new SqlCommand("Insert into Circular(title,type,url1,url2) values('" + txttitle.Text + "','" + txttype.Text + "','" + path + "','" + path1 + "')", con);
            lblinfo.Text = " Uploaded Successfully ";
            cmd.CommandType = CommandType.Text;
            con.Open();
            cmd.ExecuteNonQuery();
            con.Close();
        }
        catch (Exception ex)
        {
            Response.Write(ex.ToString());
        }
    }

您的文件可以简单地下载/打开为

your file can be simply download/open as

Response.Redirect(pdfurlfetchfromdatabase);

这篇关于关于提问的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！