I used the methods described by Dr. Clay Burch in his article titled “Customizing the Windows Forms DataGrid”, the following link:
To summarize what I did (based on above method): I created a derived DataGridTextBoxColumn, which inherits from System.Windows.Forms.DataGridTextBoxColumn class overridden the Paint method. I added an event to this class so that it is fired to allow listeners to provide customized ForeColor and BackColor – based on CurrentCellValue - to be used for the cell being painted. A derived EventArgs provide the event listener with row index, column index, and CurrentCellValue values.
My problem: When I specify a format, using DataGridTextBoxColumn.Format property, for my derived DataGridTextBoxColumn, the values in the columns are displayed unformatted. Only when the cell receives the focus, the formatted value is displayed.
The same thing happens when apply format to downloaded sample code (provided through above link). I appreciate any solution and/or clue to resolve this problem.
ADAdministrator Syncfusion Team January 16, 2005 09:26 AM
I have the same problem! Does anyone know the solution?
E.g. I want to display the date using this format:
dataColumn.Format = "MM/dd/yyyy"
But because of the FormattableTextBoxColumn-class the date is displayed as it is saved in the database (the result of GETDATE() in a stored procedure).