How to check the selected from time and to time already present in the database before inserting a new row using asp.net c#

[Democloud]

Hello Sir,

I'm trying to compare the selected from time and to is already present in the database or no.

Here is the comparison examples

in the database if the values stored are 12:00 am to 3:00am, then for the second time if i try to enter either 11m to 2:00am or 1:00am to 4:00 am the values should not get inserted . Before insertion im checking for at least 1 hour gap to be present and also the selected time must not lie between the values present in the database.

Please help me out.

Thanks

Democloud

Continue reading...