Home Forums SQL Server 2005 SQL Server 2005 General Discussion Paging Problem SQL 2005 using row_number and order by RE: Paging Problem SQL 2005 using row_number and order by

  • May 13, 2009 at 2:37 pm

    #994093

    Nish (5/13/2009)

    this solves the problem, but it seems there's another one.

    the order by column and page numbers come from UI(ASP.NET), so it'll only send column name i.e "JobCount" , but in the query it needs to be written like "JobCount.JobCount" or "Company.CompanyID" , my UI does not understand this and there are 6 different columns which comes from 3 different tables.

    Is there any workaround?

    Thanks In Advance,

    Nish.

    Hi Nish

    I have no idea what you mean with "JobCount.JobCount" for your GUI. If you use a DataTable (or a DataReader) you get only "JobCount" as result column, don't you?

    Greets

    Flo