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
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
Hi Angel,
Thanks for your reply.
I have tried as suggested but not able to succedded. Could you please provide one sample for the usage of "ObjectDataSource" and passing the Parameters for Page size and Page index.
Thanks for your help inthis regards.
Thanks & Regards,
Srini Muvvala.
Hello Srini,
Your question is more oriented in "How to implement paging with ObjectDataSource?"
You need to enable paging ot the data source and set StartRowIndex, MaximumRows and etc.
Regarding the WebDropDown you should only enable paging and set PageSize because the default value is 20.
Regarding the paging of the ObjectDataSource I may point you to some helpful links about it.
http://www.asp.net/data-access/tutorials/efficiently-paging-through-large-amounts-of-data-vb
http://forums.asp.net/t/906447.aspx
and so on.
Let us know if you need further assistance regarding this.
Hi Folks,
Did you get Paging to work using the ObjectDataSource and WebDropDown?
I am experiencing issues. I have enabled Paging at the ObjectDataSource level and at the GridEditorProvider WebDropDown configuration, and provided the PageSize at the WebDropDown configuration.
However, the startRowIndex and maximumRows values being passed to the ObjectDataSource are 0.
Help?
Thank,
Victor