ASP.NET上传下载

最新推荐文章于 2024-10-12 10:00:01 发布

liuningshiwoa

最新推荐文章于 2024-10-12 10:00:01 发布

阅读量273

点赞数

文章标签： asp.net string path insert null

本文链接：https://blog.csdn.net/liuningshiwoa/article/details/7005577

版权

strCnn = ConfigurationManager.ConnectionStrings["strcnn"].ConnectionString;
        if (this.FileUpload1.PostedFile != null)
        {
            string path = Server.MapPath("../upload/");
            FileUpload1.SaveAs(path + FileUpload1.FileName);
            string filepath = "~/upload/" + this.FileUpload1.FileName.ToString();
            using (SqlConnection sqlCnn = new SqlConnection(strCnn))
            {
                using (SqlCommand sqlCmm = sqlCnn.CreateCommand())
                {
                    sqlCmm.CommandText = "insert into fileinfo(filepath) values(@filepath)";
                    sqlCmm.Parameters.AddWithValue("filepath", filepath);
                    sqlCnn.Open();
                    int i = sqlCmm.ExecuteNonQuery();
                    if (i == 1)
                    {
                        MsgBox("上传成功！");
                    }
                    else
                    {
                        MsgBox("上传失败！请重新上传！");
                    }
                }
            }
        }
        else
        {
            MsgBox("请选择上传文件！");
        }

下载：

int index = Convert.ToInt32(e.CommandArgument);
        string name = GridView1.Rows[index].Cells[1].Text;
        Response.ContentType = "application/x-zip-compressed";
        Response.AddHeader("Content-Disposition", "attachment;filename=" + name);
        string filename = Server.MapPath(name);
        Response.TransmitFile(filename);