The database column T_AKARAT_BILLS.BILL_DT should be declared as a DATE data type.
When you use T_AKARAT_BILLS.BILL_DT in the Where clause, the best practice is to use a parameterized query where the date to be compared with T_AKARAT_BILLS.BILL_DT is passed as a DATE Data Type.
Doing so, eliminates date problems!
...
SqlCommand SQLcom = new SqlCommand();
...
SQLcom.Parameters.AddWithValue("@SelectDate",dtSelectDate);
...
SQLcom.CommandText="SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY PERS_NAME ASC) AS Row,
T_AKARAT_BILLS.*,T_AKARAT_PERS_DATA.PERS_NAME,BILL_TP_NAME
FROM T_AKARAT_BILLS join T_AKARAT_RENTS
on T_AKARAT_RENTS.ID=T_AKARAT_BILLS.RENT_ID join T_AKARAT_PERS_DATA
on T_AKARAT_PERS_DATA.ID=t_AKARAT_RENTS.TENANT_ID join T_AKARAT_BUILDINGS
on T_AKARAT_BUILDINGS.ID=T_AKARAT_RENTS.BUILDING_ID join T_AKARAT_OFFICE_DATA
on T_AKARAT_OFFICE_DATA.ID=T_AKARAT_BUILDINGS.OFFICE_ID join T_AKARAT_BILL_TP
on T_AKARAT_BILL_TP.ID=T_AKARAT_BILLS.BILL_TP_ID
where
T_AKARAT_BUILDINGS.OFFICE_ID= 3 and T_AKARAT_BILLS.BILL_DT = @SelectDate) AS TableWithRowNumbers WHERE Row > '0' AND Row <= '10'";
...