Best Way To Send DB Results To Variable

Hello all





I have a database query which will return a single value





SELECT COUNT(DISTINCT(Level_id)) FROM RoleSkill WHERE Route_ID = 1





obviously this will return only a single value and not an array of data like most database queries, therefore i would like it to be sent directly to an integer variable.





I tried doing this directly with a sqlcommand but get error that it cannot be converted to integer. Is there a good way of solving this problem?





thanks for your help





Tom