Database Automation- Execute Nonquery

ExecuteNonQuery

When to use ExecuteNonQuery

This activity helps you execute the given SQL query to update/delete a table.

Figure 1

Activity Name

Picture

ExecuteNonQuery

a

When to use ExecuteNonQuery

This activity helps you execute the given SQL query to update/delete a table.

Technical Reference

Figure 1.1

p 

S.no

Description

1

Specify the existing DB connection which is stored as a SQLConnection variable during ConnectDB

2

Specify the parameters if you are going to pass arguments in the query

3

Specify the SQL query which you need to execute

4

Select the type either Text or StoreProcedure

5

Displays the action that the activity performs in the workflow

6

Specify whether to continue executing the workflow even if the activity fails

7

Specify the Boolean variable which holds the success state of the activity.

t      DBConnection should be defined as a SqlConnection System.Data.SqlClient.SqlConnection  
                
 Type has list of choices to select from the dropdown.

a Activity: The ExecuteNonQuery helps executing a query (type or stored procedure) that is used to edit the data such as updation and deletion in the database.

 

Release date
Version
v4.0.2