C1 Community

I have an application that contains a C1FlexGrid with a column containing codes that is suitable for using a combo box with a drop-down list and a multicolumn dictionary.  The multiple columns are the code and the corresponding description of that code, which is stored in a database table (this is an unbound grid).  I create a DataMap by creating a new MultiColumnDictionary and reading the codes and their corresponding descriptions from the database and then set the flexgrid column's DataMap property to that MultiColumnDictionary.  This works fine, and the drop-down list appears very nicely formatted.  My problem is that I would like to display both the code (first column) and the description (second column) together in the grid when the cell is not in edit mode, separated by a suitable delimiting character.  However, when a DataMap is in effect, I can only get one column or the other to display in the grid, but not both when the cell is not in edit mode.  Is there any way to display both columns using the DataMap.  If not, is there an alternative?

Thanks.

jon 

You can handle this in the OwnerDrawCell method.  In the sample below it retrieves all column data from map (a MultiColumnDictionary), using the column 2 grid data as the key, and replaces the column separator with a colon. 

Private Sub C1FlexGrid1_OwnerDrawCell(ByVal sender As System.Object, ByVal e As C1.Win.C1FlexGrid.OwnerDrawCellEventArgs) Handles C1FlexGrid1.OwnerDrawCell
     If e.Col = 2 Then
          Try
             e.Text = map.Item(C1FlexGrid1.Item(e.Row, 2)).Replace(C1FlexGrid1.ClipSeparators.Chars(0), ":")          
           Catch ex As Exception
           End Try
      End If
End Sub

Regards,
Greg L

Thanks, Greg.  That does exactly what I want to do.

jon