How to sort a DateTime-column in DataView?

Question

I have a gridview with some columns and I need to sort the gridview by a date-column. But I fail in sorting it correctly. This is the code that I use:

dt.DefaultView.Sort = "Meldingsdatum asc";
gvOutlookMeldingen.DataSource = dt;
gvOutlookMeldingen.DataBind();

Can someone help me, please.

Answer 1

http://forums.asp.net/p/1267353/2393006.aspx

Answer 2

DataView stores date or anything as string type. Thus when you sort it sort by string. To sort it as DateTime , you need to convert it to DateTime before adding any data as follows,

dt.Columns["Date"].DataType = Type.GetType("System.DateTime");