Determine rows affected by Update command

[dghundt]

I use this snippet to update row(s) in the database, but need to know the number of rows affected. What is the easiest way to get the number of rows affected? Thanks!

Code: Select all

                                    
string myInsertCommand = "UPDATE callees " +
"SET result = '" + result + "' " +
"WHERE (customer.id = " + id + ") AND (status  'BUSY')";
                                    
PgSqlCommand insertData = new PgSqlCommand(myInsertCommand, pgSqlConnection1);
pgSqlConnection1.Open();
insertData.ExecuteNonQuery();

[Alexey.mdr]

You can use the following line:

Code: Select all

int recordsAffected = insertData.ExecuteNonQuery();

[dghundt]

Thank you.

[Alexey.mdr]

No problem.
Feel free to contact us if you have any further questions or concerns about the product.