Hey guys,

I'm want to retrieve results from the database, where datetime picker given value, is equal to database value.

           var _check = (from day in Check.tbl_employees
                         where day.d_from== _frm && day.d_to == _to
                       select new
                       {
                           day.desg_id,
                       }).FirstOrDefault();

datetime picker gives a value with its time,but i'm only interested in date.so i need help to compare in date which gives from the datetime picker(_from and _to) in database value(day.d_from,day.d_to).
And when comparing dates,does it compare time too?
need help ASAP.
thanks in advance.

drax

Hey guys,

I'm want to retrieve results from the database, where datetime picker given value, is equal to database value.

           var _check = (from day in Check.tbl_employees
                         where day.d_from== _frm && day.d_to == _to
                       select new
                       {
                           day.desg_id,
                       }).FirstOrDefault();

datetime picker gives a value with its time,but i'm only interested in date.so i need help to compare in date which gives from the datetime picker(_from and _to) in database value(day.d_from,day.d_to).
And when comparing dates,does it compare time too?
need help ASAP.
thanks in advance.

drax

i found the way,
its simple.

date has to be datetimepicker.value.day

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.