What steps would you follow and what objects would you use to quickly find the number of records in a database table?

There are two ways to accomplish this task:

Use a database connection and a command object to execute a SQL command that re-turns the number of rows in the table.

Use a database connection and data adapter object to create a data set for the table, and then get the number rows in the data set.