none
Sorting issues RRS feed

  • Question

  • Dears, 

    I have been facing a sorting issue while displaying data into a website.

    I have a stored procedure that select sorted data from a certain table (select * from Y  order by X DESC ) , when executing the stored procedure from .net the resulting data is not sorted.

    Does any one can help me ?

    I am using sql server 2012 and visual studio 2008 

    Regards,

    • Moved by Bob Beauchemin Thursday, May 22, 2014 1:07 AM Moved to the forum for SqlClient .NET client issues
    Wednesday, May 21, 2014 3:04 PM

All replies

  • You haven't provided enough information for anyone here to help you.  Your first step into getting help would be to provide detail schema, sample data, code both SQL and C# or VB or whatever you are using on the client side, and a specific example of the problem.

    Other than that, all I can say based on the information you've provided is, it sounds like you shouldn't have the problem you are describing.  After all you are sorting the database on the back end, so it should come out sorted on the front end.  Of course there is a problem but since you didn't provide us with any detail there's not much else I can offer.

    Wednesday, May 21, 2014 6:51 PM