[Solved] ASP.Net Image path not saving in database

Hi AnkitPal,

Check with below modified code.

protected void btnImg1_Click(object sender, System.EventArgs e)
{
    //saving file in the physical folder
    string virtualFolder = "~/Uploads/Product_Imgs/";
    //Set file extension for Photo and sign
    string file_ext = Path.GetExtension(FU_Img_1.PostedFile.FileName).ToLower();
    if (FU_Img_1.HasFile)
    {
        if (file_ext == ".jpeg" || file_ext == ".jpg" || file_ext == ".png" || file_ext == ".bmp")
        {
            string Prod_Img_1 = lblProductCode.Text + "_F" + file_ext;
            FU_Img_1.SaveAs(Server.MapPath(virtualFolder) + Prod_Img_1);
            Image1.Visible = true;
            Image1.ImageUrl = virtualFolder + Prod_Img_1;

            cnn.Open();
            SqlCommand cmd = new SqlCommand("Update_Product_Img_1", cnn);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@StatementType", "Update");
            cmd.Parameters.AddWithValue("@ProductId", SqlDbType.VarChar).Value = lblProductId.Text;
            cmd.Parameters.AddWithValue("@ProductCode", SqlDbType.VarChar).Value = lblProductCode.Text;
            cmd.Parameters.AddWithValue("@Img1_Path", SqlDbType.VarChar).Value = virtualFolder + Prod_Img_1;
            cmd.Parameters.AddWithValue("@Img1_Name", SqlDbType.VarChar).Value = Prod_Img_1;
            cmd.Parameters.AddWithValue("@Img1_Upload_UserID", SqlDbType.VarChar).Value = "";
            cmd.ExecuteNonQuery();
            cnn.Close();
            Page.ClientScript.RegisterStartupScript(this.GetType(), Guid.NewGuid().ToString(), "alert('Product's Front Image for Product. - " + lblProductCode.Text + " has been uploaded successfully.');", true);
        }
        else
        {
            Page.ClientScript.RegisterStartupScript(this.GetType(), Guid.NewGuid().ToString(), "alert('Only Images ('.JPEG, .JPG, .PNG and .BMP format') can be uploaded')");
        }
    }
}

AnkitPal says:

Code has been working and image has been return to web form and also contain a folder but data is not updated in table. Can you please check the stored procedure for me?

 I was make a mistake in stored procedure below my correct stored procedure - 

USE [SLC_Admin_Web]
GO
/****** Object:  StoredProcedure [dbo].[Update_Product_Img_1]    Script Date: 05/12/2021 12:25:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[Update_Product_Img_1]
(
	@ProductId bigint,
	@ProductCode nvarchar(50),
	@Img1_Path nvarchar(120),
	@Img1_Name nvarchar(120),
	@Img1_Upload_UserID nvarchar(120),
	@StatementType nvarchar(20) = ''
)
AS  
BEGIN
	IF @StatementType = 'Update'
	DECLARE @Img1_Upload_DT datetime
BEGIN  
	UPDATE Product_Add
	SET	Img1_Path=@Img1_Path, Img1_Name=@Img1_Name, Img1_Upload_UserID=@Img1_Upload_UserID, @Img1_Upload_DT=GETDATE()
	WHERE ProductId = @ProductId and ProductCode = @ProductCode
END
end

Now, it's working fine.

AnkitPal says:

UPDATE Product_Add

    SET Img1_Path=@Img1_Path, Img1_Name=@Img1_Name, Img1_Upload_UserID=@Img1_Upload_UserID, @Img1_Upload_DT=GETDATE()

    WHERE ProductId = @ProductId and ProductCode = @ProductCode

Change with below.

UPDATE Product_Add
SET Img1_Path=@Img1_Path, Img1_Name=@Img1_Name, Img1_Upload_UserID=@Img1_Upload_UserID, Img1_Upload_DT=GETDATE()
WHERE ProductId = @ProductId and ProductCode = @ProductCode