how to use the value returned by count function in code behind file

i know in sql query one can use count function to return the number of rows affected. I need to make a decision on the code behind file using the value returned by my sql select statement.i know in sql query one can use count function