I have a gridview that I want to be able to sort by date and also manipulate the color of the cells based on the date. In the mysql database I have that date field as a character field, and it would cause problems if i were to change it.

So the problem is the gridview is sorting it as a string and not a date. The column is a template field.

I am using a sqldatasource to connect. Was curiuos if way to fix this? Without having to manually create my dataset.

Thanks