[Solved] Combobox Inside Radgrid - Postback speed issue

[Ryan Pope]

Hey,

I currently have a grid that lists  many GridTemplateColumns within it. Three of these columns contain RadComboBoxes in them. The first cascades down to the two below it. When I change the selectedIndex of the first combo box, I trigger a postback which then fills the other two combo boxes with the appropriate values. This is all done without using an edit button, every line is editable when the grid is loaded. When the postback is triggered, it takes the grid a long time even though the code behind the selectedIndexChanged is empty and does not do anything. Do you know how I could do this without using a postback and so it only updates/looks at the line (javascript?), or to speed this postback up? I have attached the code I am using from the grid, and any help would be greatly appreciated.

It appears that when I select one RadComboBox, the postback goes through and touches every Item in teh RadGrid. I figure this because the more items that are returned into the grid, the longer it takes to fill the combo boxes for that line. Is there a way to only look at the line I am currently working on?

Thanks,
Ryan

<telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel" runat="server" Skin="Default" InitialDelayTime="500">
        </telerik:RadAjaxLoadingPanel>
        <telerik:RadAjaxPanel ID="RadAjaxPanel" runat="server" LoadingPanelID="RadAjaxLoadingPanel">
            <telerik:RadGrid ID="grdRIExceptions" runat="server" GridLines="None"
                AutoGenerateColumns="False" Width="100%" AllowPaging="True" PageSize="50"
                DataSourceID="ExceptionDataSource">
                <GroupingSettings CaseSensitive="False" GroupByFieldsSeparator="&nbsp;&nbsp;&nbsp;" />
                <ClientSettings>
                    <Scrolling ScrollHeight="500px" />
                </ClientSettings>
                <GroupHeaderItemStyle Font-Bold="True" Font-Size="12px" ForeColor="#333333" />
                <MasterTableView NoMasterRecordsText="There are no exceptions in your region with the set filters."
                    DataKeyNames="CUST_No,STC_Code,INV_PrevDocNo" ClientDataKeyNames="CUST_No"
                    DataSourceID="ExceptionDataSource" Width="100%">
                    <RowIndicatorColumn>
                        <HeaderStyle Width="20px"></HeaderStyle>
                    </RowIndicatorColumn>
                    <ExpandCollapseColumn>
                        <HeaderStyle Width="20px"></HeaderStyle>
                    </ExpandCollapseColumn>
                    <CommandItemSettings />
                    <Columns>
                        <telerik:GridBoundColumn DataField="CUST_No" EditFormHeaderTextFormat="{0}&nbsp;:" HeaderText="Customer No" UniqueName="CUST_No" Visible="False">
                            <HeaderStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False" Font-Underline="False" Wrap="True" />
                            <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Left" Wrap="True" />
                        </telerik:GridBoundColumn>
                        <telerik:GridTemplateColumn DataField="CUST_Name" EditFormHeaderTextFormat="{0}&nbsp;:" HeaderText="Cust." SortExpression="CUST_Name" UniqueName="CUST_Info">
                            <ItemTemplate>
                                <asp:LinkButton ID="btnViewCustomerInfo" runat="server">View</asp:LinkButton>
                                <asp:Label ID="lblCustNo" runat="server" Font-Underline="True" Text='<%# Eval("CUST_No") %>' Visible="False"></asp:Label>
                                <asp:Label ID="lblCustName" runat="server" Text='<%# Eval("CUST_Name") %>' Visible="false"></asp:Label>
                                <asp:Label ID="lblCustDisplay" runat="server" Text='<%# Eval("CUST_Name") + "(" + Eval("CUST_No") + ")" %>' Visible="false"></asp:Label>
                            </ItemTemplate>
                            <HeaderStyle Font-Bold="True" Font-Italic="False" Font-Overline="False" Font-Strikeout="False" Font-Underline="False" Width="30px" Wrap="True" HorizontalAlign="Left" />
                            <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Left" Wrap="True" />
                        </telerik:GridTemplateColumn>
                        <telerik:GridTemplateColumn DataField="CUST_Name" HeaderText="Customer" UniqueName="CustomerName" Display="False">
                            <ItemTemplate>
                                <asp:Label ID="lblCustDisplay2" runat="server" Text='<%# Eval("CUST_Name") + "(" + Eval("CUST_No") + ")" %>'></asp:Label>
                            </ItemTemplate>
                            <HeaderStyle Font-Bold="True" Font-Italic="False" Font-Overline="False" Font-Strikeout="False" Font-Underline="False" Width="275px" Wrap="True" HorizontalAlign="Left" />
                            <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Left" Wrap="True" />
                        </telerik:GridTemplateColumn>
                        <telerik:GridTemplateColumn HeaderText="Rental Order" UniqueName="NumOfRentalOrders">
                            <ItemTemplate>
                                <asp:Label ID="lblRONo" runat="server" Text='<%# Eval("INV_PrevDocNo") %>'></asp:Label>
                                <asp:Label ID="lblPrevDocType" runat="server" Text='<%# Eval("INV_PrevDocType") %>' Visible="false"></asp:Label>
                            </ItemTemplate>
                            <HeaderStyle Font-Bold="True" Font-Italic="False" Font-Overline="False" Font-Strikeout="False" Font-Underline="False" Wrap="True" HorizontalAlign="Left" Width="75px" />
                            <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Left" Wrap="True" />
                        </telerik:GridTemplateColumn>
                        <telerik:GridTemplateColumn DataField="INV_No" HeaderText="Inv/CM No." UniqueName="column1">
                            <ItemTemplate>
                                <asp:Label ID="lblInvNo" runat="server" Text='<%# Eval("INV_No") %>'></asp:Label>
                            </ItemTemplate>
                            <HeaderStyle Font-Bold="True" Font-Italic="False" Font-Overline="False" Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Left" Wrap="True" Width="75px" />
                            <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Left" Wrap="True" />
                        </telerik:GridTemplateColumn>
                        <telerik:GridTemplateColumn DataField="INV_PostDate" HeaderText="Inv/CM Date" UniqueName="column">
                            <ItemTemplate>
                                <asp:Label ID="INV_PostDateLabel" runat="server" Text='<%# Eval("INV_PostDate") %>'></asp:Label>
                            </ItemTemplate>
                            <HeaderStyle Font-Bold="True" Font-Italic="False" Font-Overline="False" Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Left" Wrap="True" Width="75px" />
                            <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Left" Wrap="True" />
                        </telerik:GridTemplateColumn>
                        <telerik:GridTemplateColumn HeaderText="Ship-to Information" UniqueName="STC_Code" DataField="STC_Code" GroupByExpression="STC_Code" SortExpression="STC_Code">
                            <ItemTemplate>
                                <asp:Label ID="lblSTCCode" runat="server" Text='<%# Eval("STC_Code") %>' Visible="false"></asp:Label>
                                <asp:Label ID="lblSTCName" runat="server" Text='<%# Eval("STC_Name") %>' Visible="false"></asp:Label>
                                <asp:Label ID="lblSTCUnlinked" runat="server" Text='<%# Eval("STC_Unlinked") %>' Visible="false"></asp:Label>
                                <asp:Label ID="lblSTCDisplay" runat="server"></asp:Label>
                            </ItemTemplate>
                            <HeaderStyle Font-Bold="True" Font-Italic="False" Font-Overline="False" Font-Strikeout="False" Font-Underline="False" Wrap="False" HorizontalAlign="Left" />
                            <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Left" Wrap="False" />
                        </telerik:GridTemplateColumn>
                        <telerik:GridTemplateColumn DataField="STC_City" GroupByExpression="STC_City" HeaderText="City" SortExpression="STC_City" UniqueName="STC_City">
                            <ItemTemplate>
                                <asp:Label ID="lblSTCCity" runat="server" Text='<%# Eval("STC_City") %>'></asp:Label>
                            </ItemTemplate>
                            <HeaderStyle Font-Bold="True" Font-Italic="False" Font-Overline="False" Font-Strikeout="False" Font-Underline="False" Wrap="True" Width="100px" />
                            <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Left" />
                        </telerik:GridTemplateColumn>
                        <telerik:GridTemplateColumn DataField="STC_State" GroupByExpression="STC_State" HeaderText="State" SortExpression="STC_State" UniqueName="STC_State">
                            <ItemTemplate>
                                <asp:Label ID="lblSTCState" runat="server" Text='<%# Eval("STC_State") %>'></asp:Label>
                            </ItemTemplate>
                            <HeaderStyle Font-Bold="True" Font-Italic="False" Font-Overline="False" Font-Strikeout="False" Font-Underline="False" Width="28px" Wrap="True" />
                            <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Left" Wrap="True" />
                        </telerik:GridTemplateColumn>
                        <telerik:GridTemplateColumn DataField="STC_Zip" GroupByExpression="STC_Zip" HeaderText="Zip Code" SortExpression="STC_Zip" UniqueName="STC_Zip">
                            <ItemTemplate>
                                <asp:Label ID="lblSTCZip" runat="server" Text='<%# Eval("STC_Zip") %>'></asp:Label>
                            </ItemTemplate>
                            <HeaderStyle Font-Bold="True" Font-Italic="False" Font-Overline="False" Font-Strikeout="False" Font-Underline="False" Width="55px" Wrap="True" HorizontalAlign="Right" />
                            <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Right" Wrap="True" />
                        </telerik:GridTemplateColumn>
                        <telerik:GridTemplateColumn HeaderText="Fix Type" UniqueName="FixType">
                            <ItemTemplate>
                                <telerik:RadComboBox ID="cboExceptionFixType" Runat="server" Width="125px" AutoPostBack="True" MarkFirstMatch="True" OnSelectedIndexChanged="cboExceptionFixType_SelectedIndexChanged" DropDownWidth="175px">
                                    <Items>
                                        <telerik:RadComboBoxItem runat="server" Selected="True" Text="Skip" Value="Select" />
                                        <telerik:RadComboBoxItem runat="server" Text="Always on this Address" Value="STC" />
                                        <telerik:RadComboBoxItem runat="server" Text="This Contract Only" Value="RO" />
                                    </Items>
                                </telerik:RadComboBox>
                                <asp:CheckBox ID="chkFixed" runat="server" Visible="False" />
                            </ItemTemplate>
                            <HeaderStyle Font-Bold="True" Font-Italic="False" Font-Overline="False" Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Left" Wrap="False" Width="120px" />
                            <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Left" Wrap="False" />
                        </telerik:GridTemplateColumn>
                        <telerik:GridTemplateColumn HeaderText="Assign Salesperson / Branch" UniqueName="AssignSP">
                            <ItemTemplate>
                                <telerik:RadComboBox ID="cboExceptionSalesperson" runat="server" Width="125px" DropDownWidth="175px" Height="400px" Enabled="False"  AutoPostBack="True" MarkFirstMatch="True" DataTextField="SP_Name" DataValueField="SP_Code" OnSelectedIndexChanged="cboExceptionSalesperson_SelectedIndexChanged">
                                    <Items>
                                        <telerik:RadComboBoxItem runat="server" Selected="True" Text="Select Salesperson" Value="" />
                                    </Items>
                                </telerik:RadComboBox>

                                <telerik:RadComboBox ID="cboExceptionBranch" runat="server" AutoPostBack="False" Width="125px" DropDownWidth="175px" MarkFirstMatch="True" Enabled="False" DataTextField="Code" DataValueField="Code">
                                    <Items>
                                        <telerik:RadComboBoxItem runat="server" Selected="True" Text="Select Branch" Value="" />
                                    </Items>
                                </telerik:RadComboBox>
                            </ItemTemplate>
                            <HeaderStyle Font-Bold="True" Font-Italic="False" Font-Overline="False" Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Left" Wrap="False" Width="315px" />
                            <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Left" Wrap="False" />
                        </telerik:GridTemplateColumn>
                    </Columns>
                </MasterTableView>
            </telerik:RadGrid>
        </telerik:RadAjaxPanel>

[Iana Tsolova]

Hi Ryan,

Indeed, when you perform postback from the RadComboBox, the whole grid is recreated and re-rendered. To overcome this issue, I would suggest that you load your comboboxes on demand instead of using the SelectedIndexChanged event. You can find more information here.

Additionally, I observed you have another thread open on the same subject. To avoid duplicate posting, I suggest that we continue the discussion in one of them.

Sincerely yours,
Iana
the Telerik team

[Ryan Pope]

Thank you for your response!
What I need to know now is using the item_requested method, how do I get the values from the line I am on. I need to be able to get the Zip, State & City from the line of the grid I am currently working on. How do I access the values from the Grid that I need for this method. Or is one of the other methods able to look and get these values without creating a postback?

Protected Sub RadComboBox2_ItemsRequested(ByVal sender As Object, ByVal e As RadComboBoxItemsRequestedEventArgs)
            Dim data As DataTable = GetData(e.Text)

            Dim itemOffset As Integer = e.NumberOfItems
            Dim endOffset As Integer = Math.Min(itemOffset + ItemsPerRequest, data.Rows.Count)
            e.EndOfItems = endOffset = data.Rows.Count

            For i As Integer = itemOffset To endOffset - 1
                RadComboBox2.Items.Add(New RadComboBoxItem(data.Rows(i)("CompanyName").ToString(), data.Rows(i)("CompanyName").ToString()))
            Next

            e.Message = GetStatusMessage(endOffset, data.Rows.Count)
        End Sub

    Private Shared Function GetData(ByVal text As String) As DataTable
        Dim dt As New DataTable
        Dim strConnection As String = ConfigurationManager.ConnectionStrings("RDAConnectionString").ToString

        Dim connection As SqlConnection = New SqlConnection(strConnection)
        connection.Open()
        Try
            Dim command As SqlCommand = New SqlCommand("pr_ARCPortal_Find_Salespeople_For_Exception", connection)
            command.CommandType = CommandType.StoredProcedure
            command.CommandTimeout = 0

            command.Parameters.AddWithValue("@Company", Session("ARCPortal_Company"))
            command.Parameters.AddWithValue("@RC", lblRegionalCompany.Text)
            command.Parameters.AddWithValue("@Zip", item("STC_Zip").Text)
            command.Parameters.AddWithValue("@City", item("STC_City").Text)
            command.Parameters.AddWithValue("@State", item("STC_State").Text)

            Dim adapter As SqlDataAdapter = New SqlDataAdapter(command)
            adapter.Fill(dt)
        Catch ex As Exception
        Finally
            connection.Close()
        End Try

        Return dt
    End Function

[Iana Tsolova]

Hello Ryan,

In the ItemsRequest event handler, the sender argument is the RadComboBox and its NamingContainer should be the current grid item. From then on, you can review the this article for more infoamtion on how to access grid cells and rows and their controls.

Best wishes,
Iana
the Telerik team