上载图像以存储具有图像路径的数据库 [英] upload image to store database with image path

问题描述

上传图像以使用图像路径存储数据库

upload image to store database with image path

推荐答案

请参见

使用命名空间system.data.sqlclient

并创建一个文件夹作为Album


并在按钮的单击事件上编写以下代码:

Take namespace system.data.sqlclient

and make a folder as Album


and on click event of button write this code:

string path = "";
        string ab = "";
         if (FileUpload1.HasFile)
            {
                string SFileName = Path.GetFileName(FileUpload1.PostedFile.FileName);
                int fileAppent = 0;
                while (File.Exists(Server.MapPath("~/Album/" + SFileName)))
                {
                    fileAppent++;
                    SFileName = Path.GetFileNameWithoutExtension(FileUpload1.PostedFile.FileName)
                        + fileAppent.ToString() + Path.GetExtension(FileUpload1.PostedFile.FileName).ToLower();
                }
                path = Server.MapPath("~/Album/" + SFileName);
                FileUpload1.PostedFile.SaveAs(path);
                ab = "~/Album/" + SFileName;
        SqlCommand cmd = new SqlCommand("insert into ImageURL(ImageUrl)values(@ImageUrl)", con);
        cmd.Parameters.AddWithValue("@ImageUrl",ab);
           con.Open();
        cmd.ExecuteNonQuery();
        con.Close();
         }

这篇关于上载图像以存储具有图像路径的数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！