Total number of rows

Help Activities
, ,
1

How to print how many rows are entered in sql database?
Thanks in advance

2

Hi @Cuberoot

Can you use Execute Query activity to retrieve the data from Database.

Then the output as DataTable. Let’s say dtOutput. And then you can check row count as below.

dtOutput.Rows.Count

Regards
Gokul

1 Like
3

but it shows rows is not a member of a string and I have used Execute non query.

4

Here dtOutput is the System.Datatable as the variable type

5

one thing more could you pls help me while using Execute non-Query, it inserts 1 row 6 times.

6

Assumption: you do interact with the datatable via SQL commands:

SELECT COUNT (*) FROM YourDataTableName;

Above SQL command will retrun the rows count

7

I want to write in log message not in sql

8

you want to retrieve the rows count before logging, right?

9

image
image1044×405 34.8 KB

10

No,after inserting the data into database because whenevr I enter the problem comes

11

where should I used after Execute non query?

12

should I used run query or execute non query or both queries?

13

You can use Run Query activity @Cuberoot

14

when I am using run query, it execute only 1 query

15

Can you share the screenshot ? @Cuberoot

16

Can I use run command activity?

17

You can’t able to get the count if you use Run commend activity @Cuberoot

1 Like
19

Hi @Cuberoot

Can you share the expression in the Run Query?

After the Run Query activity Just use message and print the row count in the Dt.

Have you use Run query inside the For each row activity?

20

Yes i have used in for each activity

21

Hello @Cuberoot
You can get the affected records from the output as integer, You can print it.
Once the data inserted, it results the affected rows.

image
image1140×414 17.4 KB