Missing paging support for ObjectDataSource

2 posts, 1 answers
  1. Zsolt
    Zsolt avatar
    6 posts
    Member since:
    Dec 2008

    Posted 24 Jun 2010 Link to this post

    There is an automatic feature on RadGrid (and on the default ASP.NET GridView) control for paging the rows in grid. If the datasource is an ObjectDataSource and we set the Select, Insert, Update, Delete, SelectCount methods, and set the EnablePaging="true", and the StartRowIndexParameterName, MaximumRowsParameterName properties also filled with the name of parameters of the ObjectDataSource overloaded method for paging, then the RadComboBox does not set value for the startRow and the pageSize parameter. As a side-effect the RadComboBox does not call the SelectCount method too.
     Here is an example:
     The ObjectDataSource declaration:
    <asp:ObjectDataSource ID="dsEmplTable" runat="server" DataObjectTypeName="TableObjects.EmplTable" 
            TypeName="TableObjects.EmplTableAdapter" DeleteMethod="DeleteEmplTable" 
            InsertMethod="InsertEmplTable" SelectMethod="SelectEmplTable" UpdateMethod="UpdateEmplTable" 
            OldValuesParameterFormatString="original_{0}" EnableCaching="true" CacheDuration="10" 
            SortParameterName="sortExpression" SelectCountMethod="SelectCount" 
            EnablePaging="true" StartRowIndexParameterName="startRow" MaximumRowsParameterName="pageSize" 

     The select methods of the TableAdapter class:
     [DataObjectMethod(DataObjectMethodType.Select, true)]  
    public EmplTableList SelectEmplTable(string sortExpression, int startRow, int pageSize)  
        //If we use RadComboBox then the values of the startRow and the pageSize variables are 0  
        //If we use RadGrid then these parameters filled properly by default 
        //Here we want select only a range of employees from a tons of employee 
        DataAccessLayer.GetEmployees(emplTableCollection, startRow, pageSize); 
        SelectCount = emplTableCollection.Count; 
        _empltableData = empltableCollection;   
        return _empltableData;  
    • SelectCount is a property on Adapter and its value is strored in Session variable for performance issue

     The select count method of the Adapter class:
    public int SelectCountEmplTable() 
        return SelectCount; 

     The RadComboBox that is using the declared ObjectDaraSource below:
    <telerik:RadComboBox runat="server" ID="RadComboBox2" DataTextField="EmplId" 
                   DataValueField="EmplId" HighlightTemplatedItems="true" Height="190px" Width="220px" 
                   DropDownWidth="420px" DataSourceID="dsEmplTable" EnableVirtualScrolling="true" 
                   EnableAutomaticLoadOnDemand="True" ItemsPerRequest="10" ShowMoreResultsBox="true"  
                           <li class="col1">Employee Id</li> 
                           <li class="col1"><%# DataBinder.Eval(Container.DataItem, "EmplId") %></li

     My workaround: I've created some Session variable to retrieve the required variables (startRow, pageSize) at ObjectDataSource.Selecting event and set when the ItemRequested.
            protected void Page_Load(object sender, EventArgs e) 
                this.dsEmplTable.Selecting += new ObjectDataSourceSelectingEventHandler(dsEmplTable_Selecting); 
                if (Session["RADCOMBOBOX2_STARTROW"] == null
                    Session.Add("RADCOMBOBOX2_STARTROW", 1); 
            void dsEmplTable_Selecting(object sender, ObjectDataSourceSelectingEventArgs e) 
                e.Arguments.StartRowIndex = (int)Session["RADCOMBOBOX2_STARTROW"]; 
                e.Arguments.MaximumRows = (int)Session["RADCOMBOBOX2_MAXIMUMROWS"]; 

     The questions:
     Why RadComboBox does not support a similiar paging behavior as RadGrid supports?

     Will the new beta support this automatically as RadGrid supports it?

     Maybe I can't understand well the possibilities with RadComboBox and everything works fine if the datasource is ObjectDataSource. I don't want to preclude my mistake. :) So if there is a support for ObjectDataSource paging then how should I use RadComboBox with ObjectDataSource?

  2. Answer
    Kalina avatar
    918 posts

    Posted 29 Jun 2010 Link to this post

    Hi Zsolt Molnar,

    As I can see from the code snippets provided – you use a RadComboBox with Automatic-Load-On-Demand enabled.
    The Automatic-Load-On-Demand feature supports its own paging functionality which works with all types of enumerable data sources and performs paging automatically.  
    That is why the RadComboBox control can be populated via ObjectDataSource but does not use the paging logic that this data source provides.
    However your approach to implement a different paging manually is correct.

    Feel free to contact us if you have additional questions.

    All the best,
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
Back to Top