set selected value of combobox from ItemSource bound collection property arriving from database.

3 posts, 0 answers
  1. Hazzard
    Hazzard avatar
    24 posts
    Member since:
    May 2006

    Posted 01 Nov 2011 Link to this post

    Given the xaml below, I'm populating a combobox within the gridview with a Collection of data that represents the two possible 'valid' values from the database.  Two questions.

    1. How do I set the value of combobox to the same value as it arrives from the database query and is bound to the gridview that contains the combobox and
    2. If the value from the database for the column/field/property 'Class' is 'NA' or null, I don't want a combobox to be created, or at least have it appear to the user that it is an empty cell.  (There will be nothing to select.)


    <l:Collection x:Key="EMC_Classes">
        <!-- Collection<object> -->
        <l:EMC_Class ID="1" Class="A or B" />
        <l:EMC_Class ID="2" Class="A,B,C,D" />
    <l:ValueToItemConverter x:Key="EMCID2Class"
                        ItemsSource="{StaticResource EMC_Classes}"
                        DisplayMemberPath="Class" />
    <telerik:RadGridView Name="rgvEMCTestPlans"
    <telerik:GridViewColumn Header="Class" Width="100" IsReadOnly="False" x:Name="ComboClass">
            <DataTemplate >
                <ComboBox FontSize="10"   Width="90" HorizontalAlignment="Center" 
                        ItemsSource="{StaticResource EMC_Classes}"
    public void GridLoaded(object sender, TypeLoadedEventArgs e)
       MyAppliedStandardsModels = new ObservableCollection<AppliedStandardsModel>();
       var emcClasses = new List<EMC_Class>();
       foreach (AppliedStandardsModel item in e.SType)
          rgvEMCTestPlans.ItemsSource = MyAppliedStandardsModels;
     public class EMC_Class
        public string Class { get; set; }
        public int ID { get; set; }
    private ObservableCollection<AppliedStandardsModel> _myAppliedStandardsModel;
    public ObservableCollection<AppliedStandardsModel> MyAppliedStandardsModels
        get { return _myAppliedStandardsModel; }
            _myAppliedStandardsModel = value;

    Class values flow

  2. Maya
    Maya avatar
    4062 posts

    Posted 02 Nov 2011 Link to this post

    Hi Greg,

    Generally, my commendation would be to work directly with GridViewComboBoxColumn. You can take a look at our online documentation and demos for a reference. You need to define the column's DataMemberBinding as otherwise the grid will not be able sort, group, filter or find the appropriate property from the corresponding business object. 
    Considering your second requirement, you can create a style targeting RadComboBox and set its EmptyText property just as illustrated in this demo. In the case of GridViewComboBoxColumn, it will be:

            <Style x:Key="myEditorStyle" TargetType="telerik:RadComboBox">
                <Setter Property="EmptyText" Value="Empty" />      
    <telerik:GridViewComboBoxColumn DataMemberBinding="{Binding ClubID}"
                                                    EditorStyle="{StaticResource myEditorStyle}"
                                                    ItemsSource="{Binding Clubs, Source={StaticResource MyViewModel}}">
    Otherwise, if the underlying the property is nullable and there is not value for a particular item, just an empty cell will be created and you will be able to chose items afterwards. Please take a look at the sample attached for a reference. 

    the Telerik team

    Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>

  3. Hazzard
    Hazzard avatar
    24 posts
    Member since:
    May 2006

    Posted 02 Nov 2011 Link to this post

    Thank you Maya for the code Maya. I reposted with i hope a more clear indication of what I'm attempting to do.
    Class values flow
Back to Top