~Help me~ Select conditional in C #, it is not visible : I wrote this SQL statement, then my SQL server was running.

    SELECT r.RentID,c.CustomerName,v.VehicleName,r.[Hours], r.[Hours] * v.Rent AS Total FROM Rent as r 
    INNER JOIN Customer AS c ON r.CustomerID = c.CustomerID 
    INNER JOIN Vehicle AS v ON r.VehicleID = v.VehicleID

Also when I write in C #, it does not display, although some SQL statements such as Add, Update, Delete are running normally.
I want to ask where I'm wrong and how to fix it. Thank you very much.

    public IList getRents()
    {
    IList result = new List();
    try
    {
    SqlConnection con = new SqlConnection(sCon);
    String query = "SELECT r.RentID,c.CustomerName,v.VehicleName,r.[Hours], r.[Hours] * v.Rent AS Total FROM Rent as r INNER JOIN Customer AS c ON r.CustomerID = c.CustomerID INNER JOIN Vehicle AS v ON r.VehicleID = v.VehicleID";
    //String query = "SELECT * FROM Rent";
    SqlCommand com = new SqlCommand(query, con);
    con.Open();
    SqlDataReader reader = com.ExecuteReader();
    while (reader.Read())
    {
    Rent r = new Rent();
    r.rentID = (int)reader[0];
    r.customerID = (int)reader[1];
    r.vehicleID = (int)reader[2];
    r.hours = (int)reader[3];
    //r.total = (int)reader[4];
    result.Add(r);
    }
    con.Close();
    }
    catch (Exception ex)
    {
    ex.ToString();
    }
    return result;
    }