rewriting persian date in instead of normal Date format

Question

hi friends. I have a datagrid which populated by some data from sqlserver.I have datetime filed that represent Georgian date,but i want to convert this to Persian by using PersianCalendar. I wan some kind of conversion, that gets Georgian date from database but when it comes to show on datagrid or some where else, it shows persian date.

Answer 1

For formatting you need to use the appropriate CultureInfo class, not the calendar - the names of persian cultures are fa or fa-IR, as can be seen here.

CultureInfo farsi = new CultureInfo("fa-IR");
farsi.DateTimeFormat.Calendar = new PersianCalendar(); 
DateTime date1 = new DateTime(1867, 1, 1);

Console.WriteLine(date1.ToString(farsi));

---

Update:

You can use the ItemDataBound event of the grid in order to format the date exactly as you want.