Hi
I have table in database that has Date column
when users click on button they insert their data in database in Date column insert Current date
date format that save in column is like=2013-05-11
I used below code to change above format
DateTime miladi = DateTime.Now;
System.Globalization.PersianCalendar shamsi = new System.Globalization.PersianCalendar();
DateTime shamsidate = new DateTime(shamsi.GetYear(miladi), shamsi.GetMonth(miladi), shamsi.GetDayOfMonth(miladi));
lbldate1.Text = (shamsidate.ToString("yyyy/MM/dd", System.Globalization.CultureInfo.InvariantCulture));
now in my page date shows like below
1392/02/21
is there any way that insert DATE in Table Like above date
I mean instead of 2013-05-11 it save date in database like 1392-02-21
Best Regards