how do i format date in editable grid

i use a datagrid to display my information.. there is a column showing a date.. whenever it shows the date, it display as 12/25/2004 12:00:00 AM.. i manually reformat the date by doing this : e.Item.Cells(0).Text = Replace(e.Item.Cells(0).Text, " 12:00:00 AM", "") arr = Split(e.Item.Cells(0).Text, "/") e.Item.Cells(1).Text = arr(1) & "/" & arr(0) & "/" & arr(2)) in the itemdatabound.. the problem is whenever i click on the edit link, the date inside the textboxes will show 12/25/2004 12:00:00 AM again.. how can i do to reformat it back to the DD/MM/YYYY?

Hi cynthia, If you want the date to be displayed as always "DD/MM/YYYY", do the following settings in your Global.asax file under the application_onstart event System.Globalization.CultureInfo c = new System.Globalization.CultureInfo(CultureFormat);//cultureFormat = "en-AU" System.Threading.Thread.CurrentThread.CurrentCulture = c; System.Threading.Thread.CurrentThread.CurrentUICulture = c; System.Threading.Thread.CurrentThread.CurrentCulture.DateTimeFormat.ShortDatePattern = "dd/MM/yyyy"; The above code sets the time format for the whole application as "dd/MM/yyyy". When your datagrid is loaded, you need not to explicitly convert each item using the code sent by you. I mean to say, you need not use split function etc etc... whenever you click the edit button, again the date will be displayed in the "dd/MM/yyyy" format. however if you want to do it explicitly, you can use the following code in the edit button event handler : Dim strFormat as string strFormat = e.item.cells(0).text.ToString("dd/MM/yyyy") e.item.cells(0).text = strFormat let me know if u still have problems bye ganesh

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

ganesh.ha22y ago
Hi cynthia, If you want the date to be displayed as always "DD/MM/YYYY", do the following settings in your Global.asax file under the application_onstart event System.Globalization.CultureInfo c = new System.Globalization.CultureInfo(CultureFormat);//cultureFormat = "en-AU" System.Threading.Thread.CurrentThread.CurrentCulture = c; System.Threading.Thread.CurrentThread.CurrentUICulture = c; System.Threading.Thread.CurrentThread.CurrentCulture.DateTimeFormat.ShortDatePattern = "dd/MM/yyyy"; The above code sets the time format for the whole application as "dd/MM/yyyy". When your datagrid is loaded, you need not to explicitly convert each item using the code sent by you. I mean to say, you need not use split function etc etc... whenever you click the edit button, again the date will be displayed in the "dd/MM/yyyy" format. however if you want to do it explicitly, you can use the following code in the edit button event handler : Dim strFormat as string strFormat = e.item.cells(0).text.ToString("dd/MM/yyyy") e.item.cells(0).text = strFormat let me know if u still have problems bye ganesh