c# - 捕捉零行已更新

Question

我有以下代码清除我们使用的应用程序的帐户注销标志。

try
{
    string connectionString = "Data Source=DBSERVER;Initial Catalog=AbraEmployeeSelfService;Integrated Security=False;user=FOO;pwd=BAR";

    using (SqlConnection connection = new SqlConnection(connectionString))
    {
        connection.Open();

        using (SqlCommand command = new SqlCommand("UPDATE dbo.tUSERS SET UserUnsuccessfulLoginCount = 0, UserLockoutInd = 0 WHERE LEFT(UserAbraSuiteLogicalPrimaryKey, 4) = '" + BadgeNumber + "'", connection))
        {
            command.ExecuteNonQuery();
            connection.Close();
        }
    }
}
catch (SqlException ex)
{
    MessageBox.Show(ex.Message);
}

当返回零行时，我怎样才能捕捉到它？

Answer 1

ExecuteNonQuery 将返回受影响的行数。用那个。 :)

int nbUpdatedRows;

(...)

nbUpdatedRows = command.ExecuteNonQuery();

(...)

if (nbUpdatedRows == 0) // do stuff