Total Pageviews

Thursday, November 28, 2013

ASP.Net MySql Date time conflict resolution

Add this line on your page tag   Culture="pl-PL"

this is yyyy-MM-dd format default used by mysql database for date time..

Now use any date format string in your page like DataFormatString="{0:d.M.yyyy}"  or .Tosting("mm/dd/y")

ultimately internal date time will be compatible with mysql connection.

link to a good resource on culture info 
http://www.basicdatepicker.com/samples/cultureinfo.aspx


-vinod kotiya

No comments: