When i am inserting the date, that is in my text box i am typing only the mm/dd/yyyy, but when i see the database, it looks like this - "11/8/2011 00:00:00". I used smalldatetime datatype for that field. How to rectify that one.
...
Go to the complete details ...