上载图像以存储具有图像路径的数据库

问题描述:

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

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();
         }