Delete Image File Name from Database Table and then delete image from disk in ASP.Net

You will have to first delete image from database and return its name using the following SP

ALTER procedure [dbo].[deleteproduct1] 
@behcode varchar(10) ,
@id int 
as 
begin 
declare @Image varchar(100)
set @Image = (select [image] from Image where where behcode=@behcode and id=@id )
update image 
set Image=null 
where behcode=@behcode and id=@id 

select @Image
end

Then in code delete it from disk

 protected void Button1_Click(object sender, EventArgs e)
    {
        string data = Server.UrlDecode(Request.QueryString["BehCode3"]);
        SqlCommand _cmd = new SqlCommand("deleteproduct1", _cn);
        _cmd.CommandType = CommandType.StoredProcedure; _cn.Open(); 
        _cmd.Parameters.AddWithValue("@Behcode", data);
        _cmd.Parameters.AddWithValue("@id", Convert.ToInt32(ViewState["Id"]));
        string image = _cmd.ExecuteScalar().ToString();
        if (File.Exists(Server.MapPath("~/Image/House/") + image))
        {
            File.Delete(Server.MapPath("~/Image/House/") + image)
        }
    }

Note I have given a dummy path. Make sure you se correct path so that images are deleted from disk