After fetching data from an sql server, i'm splitting some data and showing to the user in a data grid.
for example, splitting the date time and display date, time in seperate columns.

I want to sort these two display field in either ascending or descending order. How do i do this?

Intellectuals solve problems but Genoius avoid problems.

__________________
Intellectuals solve problems but Genious avoid problems.

Couldn't you do that in your SQL statement ORDER BY?

When i split datetime field into date time, how can i sort them using order by ,
coz sql does not have seperate date and time data types.

Intellectuals solve problems but Genoius avoid problems.

You could use this in your ORDER BY statement:

ORDER BY CONVERT(varchar(10), [Date Column], 101), CONVERT(varchar(5), [Date Column], 114)

The thing is, even if you split the data it still should ORDER BY in the same order as your SQL statement is ordering the date column. And this should work just as easily unless you wanted the date to order ascending and the time be descending then you would use the example above.

ORDER BY [Date Column] 'ASC or DESC

This will order by year ascending and time descending.

ORDER BY DATEPART(yy, InvDate) ASC, CONVERT(varchar(5), InvDate, 114) Desc

Richard