Forums Ultimate UI for ASP.NET Web Forms
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Srini
40
WebDropDown Paging - Server Side
posted

Hi,

I have strange scenario, we have more than 50,000 records and need to implement the paging at server side as we don’t want to load 50k records in client side implement the Paging.  We are using NHibernate and Oracle as Middle layer and DB.

Anybody has solution to implement the Paging at server side?

--

Thanks

~Srini

Parents
  • 24671
    Suggested Answer
    posted

    Hi,

    There are several level of paging, as you have correctly pointed out. The dropdown control implements server-side paging out of the box, meaning that if you set the page size to100, only that number of records will be bound in the control, and rendered to the client.

    The other paging that you are probably wanting to achieve is paging on the data source level. Depending on the way you bound the control, you may get either automatic paging (LINQDataSource for example) or have to implement it for yourself.

    So in order to answer with more details, i need some information about how exactly you bind the control. There could be a way to wrap your data source with an ObjectDataSource, and pass parameters for page size and page index, that could be translated directly to the SQL query through NHibernate, to achieve paging directly on the data source and data base level.

    Hope it helps,

    Angel

     

Reply Children