[Solved] Binding to MultiColumComboBox not work

[wan]

Hi,
I want to select data from radgrid (see picture "selectdata.jpg") after that it will bind to MultiColumComboBox (see picture "multicolumcombobox.jpg") but it not work.

My code here

<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
<script type="text/javascript">
    function UpdateItemCountField(sender, args) {
        //set the footer text
        sender.get_dropDownElement().lastChild.innerHTML = "A total of " + sender.get_items().get_count() + " items";
    }
</script>

<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server" DefaultLoadingPanelID="RadAjaxLoadingPanel1">
    <AjaxSettings>
        <telerik:AjaxSetting AjaxControlID="RadGrid2_Search">
            <UpdatedControls>
                <telerik:AjaxUpdatedControl ControlID="RadAjaxPanel_Search_New" />
                <telerik:AjaxUpdatedControl ControlID="RadGrid2_Search" />
                <telerik:AjaxUpdatedControl ControlID="RadAjaxPanel_Footer" />
                <telerik:AjaxUpdatedControl ControlID="txtPrdtOrderNo" />
                <telerik:AjaxUpdatedControl ControlID="RadComboBox_Plan" />
            </UpdatedControls>
        </telerik:AjaxSetting>
    </AjaxSettings>
</telerik:RadAjaxManager>
<telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" Runat="server" Skin="WebBlue" />

<table cellspacing="10" width="100%">
    <tr>
        <td class="style20"></td
        <td class="styleLbl">PrdtOrderNo: </td>
        <td class="styleTxtBox">
            <asp:TextBox ID="txtPrdtOrderNo" runat="server" Width="150px" Visible="false" ></asp:TextBox>
        </td>
        <td>
            <telerik:RadAjaxPanel ID="RadAjaxPanel_Search_New" runat="server">
                <asp:Button ID="btnSearch" runat="server" Text="¤é¹ËÒ" Width="100px" />
                <asp:Button ID="btnNew" runat="server" Text="New" Width="100px" />
            </telerik:RadAjaxPanel>
        </td>
    </tr>
    <tr>
        <td class="style20"></td>
        <td class="styleLbl">Plan : </td>
        <td class="styleTxtBox">
            <telerik:RadComboBox runat="server" ID="RadComboBox_Plan" Height="150px"
                Width="200px" MarkFirstMatch="true" DataSourceID="SqlDataSource_Plan"
                DataValueField="planNo"
                EnableLoadOnDemand="true"
                HighlightTemplatedItems="true" AppendDataBoundItems="true"
                OnClientItemsRequested="UpdateItemCountField"
                OnDataBound="RadComboBox_Plan_DataBound"
                OnItemDataBound="RadComboBox_Plan_ItemDataBound"
                OnItemsRequested="RadComboBox_Plan_ItemsRequested" Skin="WebBlue">
                <Items>
                    <telerik:RadComboBoxItem Text="--Please Select--" Value="" Selected="true"/>
                </Items>
                <HeaderTemplate>
                    <ul>
                        <li class="col1">Plan No</li>
                        <li class="col2">Plan Date</li>
                    </ul>
                </HeaderTemplate>
                <ItemTemplate>
                    <ul>
                        <li class="col1">
                            <%#DataBinder.Eval(Container.DataItem, "planNo")%></li>
                        <li class="col2">
                            <%#DataBinder.Eval(Container.DataItem, "date", "{0:dd/MM/yyyy}")%></li>
                    </ul>
                </ItemTemplate>
                <FooterTemplate>
                    A total of
                    <asp:Literal runat="server" ID="RadComboItemsCount" />
                    items
                </FooterTemplate>
            </telerik:RadComboBox>
            <asp:SqlDataSource ID="SqlDataSource_Plan" runat="server"
                ConnectionString="<%$ ConnectionStrings:projectConnectionString %>"
                SelectCommand="SELECT planNo, date FROM [Plan] ORDER BY date">
            </asp:SqlDataSource>
        </td>
        <td>
            <asp:RequiredFieldValidator runat="server"
                    ID="ReqFieldValidate_ddlPlan" ControlToValidate="RadComboBox_Plan"
                    ErrorMessage="*" ValidationGroup="ForSave" Display="Dynamic"
                    InitialValue="--Please Select--" />
        </td>
    </tr>
</table>


<table cellspacing="10" width="100%">
    <tr>
        <td class="style20"></td
        <td colspan="2">
            <telerik:RadGrid ID="RadGrid2_Search" runat="server"
                    AllowAutomaticDeletes="True"
                    AllowAutomaticUpdates="True" DataSourceID="SqlDataSource2_Search"
                    AllowAutomaticInserts="True"
                    AutoGenerateColumns="False"
                    GridLines="None" Width="100%" Skin="WebBlue">
                <ClientSettings EnablePostBackOnRowClick="true" EnableRowHoverStyle="true">
                    <Selecting AllowRowSelect="true" />
                </ClientSettings>
                <MasterTableView DataKeyNames="prdtOrderNo, planNo, planDate, date, productNo, productName, qtyPrdtOrder, qtyProduce, status, remark"
                        DataSourceID="SqlDataSource2_Search"
                        NoMasterRecordsText="No records to display."
                        AutoGenerateColumns="false" Name="ProductionOrder_Search">
                    <Columns>
                        <telerik:GridBoundColumn DataField="prdtOrderNo" DefaultInsertValue=""
                            HeaderText="prdtOrderNo" SortExpression="prdtOrderNo"
                            UniqueName="prdtOrderNo" ReadOnly="True" Display="false">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="planNo" DefaultInsertValue=""
                            HeaderText="planNo" SortExpression="planNo"
                            UniqueName="planNo" ReadOnly="True">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="planDate" DefaultInsertValue=""
                            HeaderText="planDate" SortExpression="planDate" UniqueName="planDate"
                            DataFormatString="{0:dd/MM/yyyy}">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="date" DefaultInsertValue=""
                            HeaderText="date" SortExpression="date" UniqueName="date"
                            DataFormatString="{0:dd/MM/yyyy}">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="productName" DefaultInsertValue=""
                            HeaderText="productName" SortExpression="productName" UniqueName="productName">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="qtyPrdtOrder" DefaultInsertValue=""
                            HeaderText="qtyPrdtOrder" SortExpression="qtyPrdtOrder" UniqueName="qtyPrdtOrder"
                            ItemStyle-HorizontalAlign="Right" DataFormatString="{0:N}">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="qtyProduce" DefaultInsertValue=""
                            HeaderText="qtyProduce" SortExpression="qtyProduce" UniqueName="qtyProduce"
                            ItemStyle-HorizontalAlign="Right" DataFormatString="{0:N}">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="status" DefaultInsertValue=""
                            HeaderText="status" SortExpression="status" UniqueName="status">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="remark" DefaultInsertValue=""
                            HeaderText="remark" SortExpression="remark" UniqueName="remark" Visible="false">
                        </telerik:GridBoundColumn>
                    </Columns>
                </MasterTableView>
            </telerik:RadGrid>
            <asp:SqlDataSource ID="SqlDataSource2_Search" runat="server"
                ConnectionString="<%$ ConnectionStrings:projectConnectionString %>"
                SelectCommand="SELECT ProductionOrder.prdtOrderNo, ProductionOrder.planNo, [Plan].date AS planDate, ProductionOrder.date, ProductionOrder.productNo, Product.productName, [Plan].qtyPlan, ProductionOrder.qtyPrdtOrder, ProductionOrder.qtyProduce, ProductionOrder.status, ProductionOrder.remark FROM [Plan] INNER JOIN Product ON [Plan].productNo = Product.productNo INNER JOIN ProductionOrder ON [Plan].planNo = ProductionOrder.planNo">
            </asp:SqlDataSource>
        </td>
    </tr>
</table>

<center>
    <telerik:RadAjaxPanel ID="RadAjaxPanel_Footer" runat="server">
        <asp:Button ID="btnSave" runat="server" Text="Save" Width="100px" ValidationGroup="ForSave" />
        <asp:Button ID="btnCancel" runat="server" Text="Cancel" Width="100px"/>
    </telerik:RadAjaxPanel>
</center>

<asp:SqlDataSource ID="SqlDataSource_ddlProduct" runat="server"
        ConnectionString="<%$ ConnectionStrings:projectConnectionString %>"
        SelectCommand="SELECT productNo, productName FROM Product WHERE status = 'Active'">
</asp:SqlDataSource>

</asp:Content>

Protected Sub RadComboBox_Plan_DataBound(ByVal sender As Object, ByVal e As EventArgs)
    'set the initial footer label
    CType(RadComboBox_Plan.Footer.FindControl("RadComboItemsCount"), Literal).Text = Convert.ToString(RadComboBox_Plan.Items.Count)
End Sub
Protected Sub RadComboBox_Plan_ItemsRequested(ByVal sender As Object, ByVal e As RadComboBoxItemsRequestedEventArgs)
    SqlDataSource_Plan.SelectCommand = "SELECT planNo, date FROM [Plan] ORDER BY date"
    RadComboBox_Plan.DataBind()
End Sub
Protected Sub RadComboBox_Plan_ItemDataBound(ByVal sender As Object, ByVal e As RadComboBoxItemEventArgs)
    'set the Text and Value property of every item
    'here you can set any other properties like Enabled, ToolTip, Visible, etc.
    e.Item.Text = Convert.ToDateTime(DirectCast(e.Item.DataItem, DataRowView)("date").ToString()).ToString("dd/MM/yyyy")
    e.Item.Value = (DirectCast(e.Item.DataItem, DataRowView))("planNo").ToString()
End Sub
Private Sub RadGrid2_Search_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles RadGrid2_Search.SelectedIndexChanged
    '''' set header
    txtPrdtOrderNo.Text = RadGrid2_Search.SelectedItems(0).OwnerTableView.DataKeyValues(RadGrid2_Search.SelectedItems(0).ItemIndex)("prdtOrderNo")
    RadComboBox_Plan.SelectedValue = RadGrid2_Search.SelectedItems(0).OwnerTableView.DataKeyValues(RadGrid2_Search.SelectedItems(0).ItemIndex)("planNo")
End Sub

Thanks

[Vasil]

Hello Wan,

You should use either RadAjaxPanel or RadAjaxManager to ajaxify multiple asp:Panels. Note that it is not recommended to mix the two ajaxifying techniques, because ajaxifying RadAjaxPanels using RadAjaxManager would cause wrong update behavior.

Find more information here:
http://www.telerik.com/help/aspnet-ajax/ajax-ajaxmanager.html
http://www.telerik.com/help/aspnet-ajax/ajax-ajaxpanel.html

Kind regards,
Vasil
the Telerik team

[wan]

Hi,
Many thanks for your quick reply.
I do following your suggestion, but it still NOT WORK.
I try to do same with RadComboBox and it work!!!
I don't know why?

[Vasil]

Hello Wan,

In the RadGrid2_Search_SelectedIndexChanged function loop thought all elements of the RadComboBox_Plan and then compare the value of each of them with the required planNo. If the value matches then set the current item to be selected.

Dim requiredValue As String = RadGrid2_Search.SelectedItems(0).OwnerTableView.DataKeyValues(RadGrid2_Search.SelectedItems(0).ItemIndex)("planNo")

Dim i As Integer = 0
While i <= RadComboBox_Plan.Items.Count - 1
  If RadComboBox_Plan.Items(i).Value = requiredValue Then
    RadComboBox_Plan.Items(i).Selected = True
    Return
  End If
End While

Additionally, you could check the resources bellow:
Binding RadComboBox to ASP DataSource components
Working with Items of RadComboBox in Server Side Code

Greetings,
Vasil
the Telerik team