上传图片到数据库中并显示出来.txt

来自「学习积累的代码段」· 文本 代码 · 共 22 行

string ImageFullname = this.FileUpload1.FileName;
        string ImageType = ImageFullname.Substring(ImageFullname.LastIndexOf(".") + 1);
        string ImageWpath = "upimage\\" + ImageFullname;
        if (ImageType == "jpg" || ImageType == "bmp" || ImageType == "gif")
        {
            this.FileUpload1.SaveAs(Server.MapPath("upimage") + "\\" + ImageFullname);
            this.imgshop.ImageUrl = ImageWpath;
            Response.Write("<script language='javascript'>alert('修改成功');location.href='myhome.aspx'</script>");
            //新修改的图片显示出来
            SqlConnection con = db.ceratcon();
            con.Open();
            SqlCommand cmd = new SqlCommand(" update MyShop set ShopImage=@ShopImage", con);
            cmd.Parameters.Add("@ShopImage", SqlDbType.VarChar);
            cmd.Parameters["@ShopImage"].Value = ImageWpath.ToString();
            cmd.ExecuteNonQuery();
            con.Close();
        }
        else
        { Response.Write("<script language='javascript'>alert('你上传的图片格式有错误！')</script>");
        }