Currently I have a datagridview that I created the columns at run time and added data to it row by row. (No databinding) How do I make a column that has dates (01/01/2009) sortable by the date? It appears to interpret it as a string is there a way to say this is a date column treat it like a date not a string. I tried creating a cell template but it doesn't work. Do I have to make the data into YYYY-MM-DD format somehow when the user clicks the header and then switch it back?
Dim txtCelldate As DataGridViewCell = New DataGridViewTextBoxCell
'Put specifics about the cell here, such as backcolor, etc.
.Style.Format = "DD/MM/YYYY"