order by not working once data fil

Question

hi Team in my project there one requirement i wrote one query which return data in that i have apply order by clause on date column which works fine in sql but once i fill datatable it lost order by clause and same i bind to datagride(winform) which not working please help me

Rohit · Answer

with cte as ( select distinct rm.CallingTime ls.LevelName ls.ProjectName ls.StatusSetDate NextCallDate IsAlloted IsFixedCallTime ls.LevelIDls.ProjectStatusID from vwClientReminderList as rm left join vwReClientReminder_latest as lrm on lrm.clientid=rm.clientid left join vwReClientLatestLevelDtls_latest ls on ls.ClientID=rm.ClientID where UserID=122 and ReminderDiscarded=0 ) select * from cte order by NextCallDate desc this my query but problem not with my query now same i query i using in ado .net and return dt(Datatable) in that Nextcaldate not orderd which exist in query also after binding to gridview in winform in sort properly i have check sorting related property also please help me

Amit Gupta · Answer

Please share your query so that we can understand where the problem is?