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
Matt Sheuerman
140
WebDropDown Lazy Loading and Paging not showing up
posted

I have a page with several WebDropDowns that contain different criteria the user can select for a report.

Several of these dropdowns are filled from the user's database and I'm running into an issue with one of our users who has over 100K records in some of these tables.

Lets look at 1 dropdown in particular:

<ig:WebDropDown ID="checkCustomDegree" runat="server" CssClass="ddl0 fontSmall" DisplayMode="DropDown" EnableLoadOnDemand="true" Enabled="true" EnableClosingDropDownOnSelect="false" EnableMultipleSelection="true" MultipleSelectionType="Checkbox" DropDownContainerHeight="200px"
DropDownAnimationType="EaseIn" NullText="DEGREES..." Font-Size="Small" Width="90%" DropDownContainerWidth="250px" EnableDropDownAsChild="false">
</ig:WebDropDown>

I have enabled LoadOnDemand to try to keep the page from taking over a minute to load and that worked.  However, it only load the first 20 or 30 records.  My understanding is that when I scroll down to the bottom of the screen it should load more, but nothing happens when I hit the bottom of the page.

I also tried removing LoadOnDemand and instead adding paging:

<ig:WebDropDown ID="checkCustomDegree" runat="server" CssClass="ddl0 fontSmall" DisplayMode="DropDown" EnablePaging="true" PageSize="30" PagerSettings-PagerMode="NextPreviousFirstLast" Enabled="true" EnableClosingDropDownOnSelect="false" EnableMultipleSelection="true" MultipleSelectionType="Checkbox" DropDownContainerHeight="100"
DropDownAnimationType="EaseIn" NullText="DEGREES..." Font-Size="Small" Width="90%" DropDownContainerWidth="250px" EnableDropDownAsChild="false">
</ig:WebDropDown>

In this case it loads 30 rows, I scroll to the bottom of the screen and I do not see any paging controls.

I am filling the list and setting the datasource at run-time with this code:

query = "SELECT DISTINCT(degree) FROM PROSPECTSdegrees ORDER BY degree"

dh.SelectData(query)

checkCustomDegree.TextField = "degree"
checkCustomDegree.ValueField = "degree"
checkCustomDegree.DataSource = dh.Ds.Tables(0)

What options do I have to get this page loading in a reasonable amount of time?  I just learned I need to add one more table for this user that has 131,000 rows, so I'm going to need some kind of solution to work.