Update in database

Hi @arjun27 ,
I have tested your situation to my side . I identified that have to change the command type is to “storedprocedure”. If i set it as “Text”, Yes I am getting error what you have specified in the above.

Below i have attached the screen and my sample files also.

In the sample file , It has Execute query and Execute Non Query (Both)

File : Update Database.zip (2.6 KB)