Datagrid Column Sort Not Working

Question

Hi

I have a Datagrid that's bound to a DataTable. The data is generated using a SQL Server sp. Everything seems fine initially, however when I trigger sort in any column header in the Datagrid the sort doesn't sort the column as it should do.

For instance, sorting a column with the following data 1,2,4,3,8,5,10,9 would produce 1,2,3,4,8,10,9,5.

I have used Datagrids before and have never come across this problem. I have compared design setup with other Datagrids that sort fine and there are no differences.

I am using .Net framework 1.0.

NB I am using a DataGrid control, not a DataGridView control.

Any input would be much appreciated.

Thanks