Database : select query

Hi, If we hit a select query in database and need to verify whether query has fetched any rows or not. Please suggest how can we verify it.

execute query returns a datatable, so you could use table.rows.count to get the number of rows.


Task which you want to perform

Thanks a lot for response. It is working fine.