The orders after 12 am to 7 am not show timer problem

[Arjay]

Instead of DATEDIFF use something else like calculating the start and end date times and use between.

Debug this using a sql query before trying this in your C# code.