Hi,
    I am displaying data retrieved from my module database within a gridview control. I would like to be able to sort the data to view by a selected column. I think I have to amend my getlist stored procedure to do this but cannot get it to work. I have tried writing the stored procedure to accept a variable "@sort int" and then adding an "order by @sort" clause at the end of the procedure but this does not work.Can anyone tell me what I am doing wrong?

Thanks,
Phil

Thanks for the reply. The stored procedure I have written is:

ALTER PROCEDURE PortfolioListSelect
AS
BEGIN
    SELECT
        ID AS ItemId,
        UserID,
        UserName,
        Email,
        Homepage,
        Image1,
        Image1Link,
        Image1Detail,
        Image2,
        Image2Link,
        Image2Detail,
        Image3,
        Image3Link,
        Image3Detail,
        Image4,
        Image4Link,
        Image4Detail,
        Image5,
        Image5Link,
        Image5Detail,
        Image6,
        Image6Link,
        Image6Detail,
        Image7,
        Image7Link,
        Image7Detail,
        Image8,
        Image8Link,
        Image8Detail,
        Image9,
        Image9Link,
        Image9Detail,
        Image10,
        Image10Link,
        Image10Detail,
        UserSkills,
        UserPosRatings,
        UserNegRatings        
    FROM [Portfolio]
END

How would I modify this procedure so I can order the data by a selected column in the gridview and what other code would I need to include?

Thanks,
Phil

This may help:

Working with Data in ASP.NET 2.0 :: Paging and Sorting Report Data

---

Michael Washington
http://ADefWebserver.com

A Free Open Source DotNetNuke Help Desk Module