how do i format date in editable grid

Question

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?

ganesh.ha · Answer

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