0) Don't use string concatenation to for an SQL statement; use a parameterized query.
1) If you are selecting a single value you can use ExecuteScalar
2) If you are selecting multiple values, then you will need something else -- perhaps ExecuteReader.
string sql = "SELECT ID from Rooms where RentDue = @rentdue";
SqlCommand execsql = new SqlCommand(sql, cn);
execsql.Parameters.AddWithValue ( "@rentdue" , 22 ) ;
cn.Open();
...