Forums Retired Products and Controls
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Lars
210
Dropdown Fields Show Values Not Text when I use more than 1 Dropdown
posted

I have a grid in which I have the following fields
    IssueCode    - Defined as a DropDown
    IssueStatus  - Defined as a DownDown
    StartDate     - Defined as a DateChooser
    EndDate      - Defined as a DateChooser

The two dropdowns are defined using the following ValuesList information

In the ASPX page the columns are defined like...
    <igtbl:UltraGridColumn BaseColumnName="IssueCode" IsBound="True" Key="IssueCode" Type="DropDownList" Width="300px">
         <Header Caption="Issue Code">
             <RowLayoutColumnInfo OriginX="1" />
         </Header>
         <CellStyle BackColor="Salmon">
         </CellStyle>
         <Footer>
            <RowLayoutColumnInfo OriginX="1" />
         </Footer>
    </igtbl:UltraGridColumn>
    <igtbl:UltraGridColumn BaseColumnName="IssueStatus" IsBound="True" Key="IssueStatus" Type="DropDownList" Width="80px">
         <Header Caption="Status">
             <RowLayoutColumnInfo OriginX="2" />
         </Header>
         <CellStyle BackColor="Salmon">
         </CellStyle>
         <Footer>
            <RowLayoutColumnInfo OriginX="2" />
         </Footer>
    </igtbl:UltraGridColumn>

 In the code behind the valuelist are defined like this...
    //Set dropdown for Issue Code
    ValueList vlIssueCode = uwgIssues.Bands[0].Columns.FromKey("IssueCode").ValueList;
    vlIssueCode.DataSource = ds1;
    vlIssueCode.DataMember = "IssueControl";
    vlIssueCode.ValueMember = "DataValue";
    vlIssueCode.DisplayMember = "DataText";
    vlIssueCode.DataBind();
    //Set dropdown for Issue Status|
    ValueList vlIssueStatus = uwgIssues.Bands[0].Columns.FromKey("IssueStatus").ValueList;
    vlIssueStatus.DataSource = ds1;
    vlIssueStatus.DataMember = "IssueStatus";
    vlIssueStatus.ValueMember = "DataValue";
    vlIssueStatus.DisplayMember = "DataText";
    vlIssueStatus.DataBind();

When the grid displays the IssueCode field displays the DataText value in the field and the dropdown works just fine. But in the Status field it displays the DataValue in the field but when you click the cell it displays the dropdown and it too works just fine. It's just when the grid is displayed that the second filed defined as a dropdown field doesn't display the correct text value it displayes the code value. This grid also has child records and the dropdowns in those fields also don't display the correct value. But the dropdowns work correctly so my clients can see the proper values when they click in the cells.

Thanks for any help...

 

  • 14049
    Offline posted
    Just to clarify on the properties use:
    DataMember should be the table name inside of the ds1 data set;
    ValueMember should be a field name in the table defined in DataMember.
    This field values will be used for the values of the drop down;
    DisplayMember should be a field name in the table defined in DataMember.
    This field values will be used for the text of the drop down.