asp.net简单的上传图片保存相对路径到数据库！

 

//上传图片

protected void Updated_Click(object sender, EventArgs e)
    {
        string name = FileUpload1.FileName;       //获取文件名
        string type = name.Substring(name.LastIndexOf(".") + 1);    //获取文件类型
        string ipath = Server.MapPath("Images") + "\\" + name;    //获取文件路径
        string wpath = "Images\\" + name;        //设置文件保存相对路径(这里的路径起始就是我们存放图片的文件夹名)

        string query1 = "insert into Images values('" + wpath + "')";

        if (type == "jpg" || type == "gif" || type == "bmp" || type == "png")
        {
            FileUpload1.SaveAs(ipath);//服务器保存路径
            DbHelperSQL.Query(query1);
            ShowImage();//重新绑定
        }

    }
   

 

//显示

private void ShowImage()
    {
        string query2 = "select * from Images where Image_ID='1'"; // where Image_ID='1'+ Convert.ToInt32(TextBox1.Text);
        SqlDataReader sdr = DbHelperSQL.ExecuteReader(query2);
        string wpath2 = "";
        while (sdr.Read())
        {
            wpath2 = sdr[1].ToString();    //从数据库中获得相对路径
        }
        sdr.Close();
        Image1.ImageUrl = wpath2;    //图片显示路径就是相对路径
    }