how to check the date in the table

younis abdeljawwad

14y2k

Hi all,
am developing desktop application on visual studio 2010 professional using c#,
i have table that have two columns start_date and end_date, these values is taken from DateTimePicker and stored in the table ( like this format 5/28/2012)
now i want to add another item that have start_date and end_date, how can i check is the new item start and end date is not between any other old item start and end date in the table in the database,

i mean the start and the end of any item date in the table data is not like any other , every item have unique start and end date
if conflict in date a message is appear that i have conflict in date and i should add a new date start and end that is not exist in the table data
thanks all

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Santhosh Kumar Jayaraman14y ago
Accepted answer
select count(*) from course where coursestartdate<=@coursestartdate and courseenddate>=@courseenddate

here @coursestartdate and @courseenddate are new parameters which you are trying to validate
0
younis abdeljawwad14y ago
i thing it is not enough because maybe the new start and end is out of range of the old start and end !!!
what you do sometime work and sometime not work , for not i can't understand the condition you put !!
0