上载图像以存储具有图像路径的数据库
问题描述:
上传图像以使用图像路径存储数据库
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();
}