sql - String to Datetime Conversion in Ajax CalendarExtender. -


in calender control : when select date, display in textbox in format : 15-06-2015 00:00:00 means "dd-mm-yyyy hh:mm:ss".

after converted textbox text datetime datatype using

datetime dt = convert.todatetime(txtdate.text);

and store database.

in database store in format : 2015-06-15 means "yyyy-mm-dd" because column datatype date.

in ajax calendarextender : using calendarextender ajexcontroltoolkit. don't use format attribute. default display in textbox in format : 6/16/2015 menas "mm/dd/yyyy"

try convert textbox string datetime datatype using same code

datetime dt = convert.todatetime(txtdate.text);

but error displayed "string not recognized valid datetime"

even try

datetime dt = datetime.parse(txtdate.text);

but same error displayed every time.

you have 2 options, provide format attribute ajax control or use datetime.parseexact.

<ajaxtoolkit:calendar runat="server"     targetcontrolid="date1"     cssclass="classname"     format="yyyy-mm-dd"     popupbuttonid="image1" /> 

http://www.ajaxcontroltoolkit.com/calendar/calendar.aspx

using parseexact:

datetime date = datetime.parseexact("6/16/2015", "m/dd/yyyy", null); 

Comments

Popular posts from this blog

powershell Start-Process exit code -1073741502 when used with Credential from a windows service environment -

twig - Using Twigbridge in a Laravel 5.1 Package -

c# - LINQ join Entities from HashSet's, Join vs Dictionary vs HashSet performance -