select row_count , C.Text From sys.dm_exec_sessions ES ,sys.dm_exec_connections EC

Cross apply sys.dm_exec_sql_text (Ec.most_recent_sql_handle) C

where Es.session_id= EC.session_id

Not sure why you try to find out number of result sets. But above query can guide you.