ExecuteNonQuery
This activity helps you execute the given SQL query to update/delete a table.
Figure 1
|
Activity Name |
Picture |
|
ExecuteNonQuery |
|
This activity helps you execute the given SQL query to update/delete a table.
|
Figure 1.1
|
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. |
DBConnection should be defined as a SqlConnection System.Data.SqlClient.SqlConnection
Type has list of choices to select from the dropdown.
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.