ExecuteQuery
This activity helps you call and execute the given SQL query in the database.
Figure 1
|
Activity Name |
Picture |
|
ExecuteQuery |
|
|
Figure 1.2
|
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 datatable variable which holds the data that returns after executing the query. |
DBConnection should be defined as a SqlConnection System.Data.SqlClient.SqlConnection
Type has list of choices to select from the dropdown.
Activity: The ExecuteQuery helps executing a query (type or stored procedure) that interacts with the database to extract/retrieve the required data.