DataView.Sort Question

Hi,

I have a Dataview object which I use to bind to a Datagrid.

It has 5 columns, 2 are string ,3 are numeric datatypes.

If I use the 'Sort' Function of the Dataview Object, it sorts the string
columns correctly, however the numeric columns are not ordered as they are
when I do a Database select using an 'ORDER BY' command.


I was wondering if I am missing something...how can I sort the numeric
columns to be sorted numerically? rather than like a string.

Cheers,
Richard