Hi, I'm facing similar issue. I'm doing sorting on server side and date format used is DD/MM/YYYY. The data is getting sorted in correct order in backend but when this data is bound to grid it looks like string sotred data. So 01/02/2011 comes before 05/01/2011.

Hi pradnyavaidya,

verify two things.

1. In ultragrid view column 'DataType="System.DateTime"' is set

2. Verify the data type of the column which is in datatable or dataset ( verify in VS in debug mode )

If ultragid's column is set as datetime than the data which is binding with this column must be datetime so it will sort like datetime and display format can be change.

Thanks for the reply. I've checked both pts. The list which is bound to grid has column defination for this particular date column as String. In ultrawebgrid I've set column datatype as System.DateTime. Is this causing conflict? I can not change column definition business object (base of the list) from string to DateTime. Is there any alternate?

ultrawebgrid column and the data both must be in date time than it will sort perfectly. If type is string it will sort based on character not based on date.

Sorry, I am not at expert level so currently i don't have alternate solution of this.