In my proj i'm using ms-access DB.. i have two fields namely sms_date,sms_time.. i myself enter the records to the DB..
I need to populate the gridview with the records within the given range of date.. i hav a calendar control to select the date(mm/dd/yyyy) and user should type the time(hh:mm:ss).
But the thing is tat wen i select the date from DB, i get the time also in gridview date field .. ex: 1/3/2011 12:00:00 AM.
Similarly for the time field, it comes default wit the date.. ex: 12/30/1899 12:45:23 AM..
So its givin me error wen i check these date and the date wat i enter in the front end..
In the access DB itself i set the format for sms_date as Shortdate and for time as ShortTime.. but no use wen i get the values into the gridview..
Some1 pls help me out..!!! Thanks..:)