radcombobox not bind into radgrid with datakeyname

[Dhamodharan]

Hi,

I have radcombobox into radgrid. i am using sqldatasource for bind radcombobox using radgrid datakey names. but it is not bind.

Here my code,

    <telerik:RadGrid ID="rgAddPlans" runat="server" AutoGenerateColumns="False" DataSourceID="sdsDispayPlans" DataKeyNames="sp_pln_id"
                            Width="740px" GridLines="Both">
                            <MasterTableView HierarchyDefaultExpanded="true" AutoGenerateColumns="false" CommandItemDisplay="Top"
                                DataKeyNames="sp_pln_id">                              
                           
                                <Columns>                    
                                  
                                     <telerik:GridTemplateColumn HeaderText="Existing Coverage" HeaderStyle-Font-Bold="true">
                                        <ItemTemplate>
                                            <asp:Label ID="lblExistCvg" runat="server" SkinID="NoBold" Text='<%# Bind("cvg_typ_code") %>'></asp:Label>
                                              <asp:HiddenField ID="hfWaiveStatus" runat="server" />
                                        </ItemTemplate>
                                        <ItemStyle HorizontalAlign="Center" Wrap="false" />
                                        <HeaderStyle Width="120px" HorizontalAlign="Center" Wrap="true" />
                                    </telerik:GridTemplateColumn>
                                    <telerik:GridTemplateColumn HeaderText="Coverage" HeaderStyle-Font-Bold="true">
                                        <ItemTemplate>
                                            <telerik:RadComboBox ID="ddlCoverage" AutoPostBack="false" Width="110px" DataSourceID="sdsddlCoverage"
                                                runat="server" OnSelectedIndexChanged="ddlCoverage_IndexChanged"  DataTextField="cvg_typ_code"
                                                DataValueField="pln_cvg_id">                                               
                                            </telerik:RadComboBox>
                                            
                                            <asp:Label ID="lblCoverage" runat="server" SkinID="NoBold" Style="padding-left: 50px;
                                                text-align: center" Visible="false"></asp:Label>
                                        </ItemTemplate>
                                        <HeaderStyle Width="110px" HorizontalAlign="Center" />
                                        <ItemStyle HorizontalAlign="Center" />
                                    </telerik:GridTemplateColumn>                              
                                </Columns>                           
                            </MasterTableView>                       
                        </telerik:RadGrid>
                           <asp:SqlDataSource ID="sdsddlCoverage" runat="server" ConnectionString="<%$ ConnectionStrings:MyConnStr %>"
        ProviderName="<%$ ConnectionStrings:MyConnStr.ProviderName %>" SelectCommand="SELECT  
                                               ct.description
                                             , ct.cvg_typ_code
                                             , pct.pln_cvg_id  
                             FROM  
                                               plan_coverage_types pct  
                                               JOIN coverage_types ct ON ( pct.cvg_typ_id = ct.cvg_typ_id )   
                             WHERE  
                                               pct.pln_id = :sp_pln_id   order by ct.cvg_typ_id ">
        <SelectParameters>
            <asp:Parameter Name="sp_pln_id" />          
        </SelectParameters>
    </asp:SqlDataSource>

Her is my code. i want radcombobox bind depends sp_pln_id. but it is not binding.

Please give me tips for this one.


Thanks,
Dhamu.

[Maria Ilieva]

Hi,

You need to bind the SelectedValue of your combobox to the data field for your grid column.For example:

<telerik:GridTemplateColumn DataField="Coverage"  HeaderText="Coverage" UniqueName="Coverage">
                        <EditItemTemplate>
                            <telerik:RadComboBox ID="comboCoverage" SelectedValue='<%#Bind("Coverage") %>' runat="server">
                            </telerik:RadComboBox>
                        </EditItemTemplate>
 </telerik:GridTemplateColumn>

Kind regards,
Maria Ilieva
the Telerik team

[Maria Ilieva]

Hi,

You need to bind the SelectedValue of your combobox to the data field for your grid column.For example:

<telerik:GridTemplateColumn DataField="Coverage"  HeaderText="Coverage" UniqueName="Coverage">
                        <EditItemTemplate>
                            <telerik:RadComboBox ID="comboCoverage" SelectedValue='<%#Bind("Coverage") %>' runat="server">
                            </telerik:RadComboBox>
                        </EditItemTemplate>
 </telerik:GridTemplateColumn>

Kind regards,
Maria Ilieva
the Telerik team