title: Fill GridViewDataComboBoxColumn using value of the aspxgridview
body: <p>I'm a novice C# programmer (about 6 months) and I'm using DevExpress components in my current work with ASP.NET.</p>
  
  <p>I have no idea about fill a combox that is inside my grid.
  The problem is basically this:
  For each row in the grid I have a title / billet to show and in one column I have the list of bank accounts of when this title / billet was paid.
  I need to show at least one record where they exist, or empty when the title / billet has not yet been paid.</p>
  
  <p>I looked out some examples and threads here in the site, I tried to implement but nothing that brought me some effective result.</p>
  
  <p>The aspx looks like this one:
  `</p>
  
  <pre><code>&lt;dx:ASPxGridView ID="devGridView" ClientInstanceName="devGridView" runat="server"
     AutoGenerateColumns="False" EnableCallBacks="False" KeyFieldName="ID_TITULO"
      Width="100%" DataSourceID="odsTitulosReceber"&gt;
     &lt;Settings ShowHeaderFilterButton="true" ShowGroupPanel="true" ShowFooter="true" ShowFilterRow="true" /&gt;
     &lt;SettingsBehavior AllowFocusedRow="true" /&gt;
     &lt;SettingsDetail ShowDetailRow="true" /&gt;
     &lt;SettingsPager PageSize="100"&gt;
     &lt;/SettingsPager&gt;
     &lt;ClientSideEvents RowClick="behavior.rowClick" /&gt;
     &lt;Columns&gt;
          &lt;dx:GridViewDataTextColumn FieldName="ID_DOCUMENTO_FISCAL" Caption="Doc. Fiscal"
           Width="70px"&gt;
          &lt;/dx:GridViewDataTextColumn&gt;
          &lt;dx:GridViewDataTextColumn FieldName="DS_PESSOA" Caption="Pessoa"&gt;
          &lt;/dx:GridViewDataTextColumn&gt;
          &lt;dx:GridViewDataTextColumn FieldName="ST_TITULO" Caption="Situação"&gt;
          &lt;/dx:GridViewDataTextColumn&gt;
          &lt;dx:GridViewDataTextColumn FieldName="DT_EMISSAO" Caption="Emissão"&gt;
            &lt;PropertiesTextEdit DisplayFormatString="dd/MM/yyyy"&gt;
            &lt;/PropertiesTextEdit&gt;
          &lt;/dx:GridViewDataTextColumn&gt;
          &lt;dx:GridViewDataTextColumn FieldName="DT_VENCIMENTO" Caption="Vencimento"&gt;
            &lt;PropertiesTextEdit DisplayFormatString="dd/MM/yyyy"&gt;
            &lt;/PropertiesTextEdit&gt;
          &lt;/dx:GridViewDataTextColumn&gt;
          &lt;dx:GridViewDataTextColumn FieldName="DT_PAGAMENTO" Caption="Pagamento"&gt;
            &lt;PropertiesTextEdit DisplayFormatString="dd/MM/yyyy"&gt;
            &lt;/PropertiesTextEdit&gt;
          &lt;/dx:GridViewDataTextColumn&gt;
          &lt;dx:GridViewDataTextColumn FieldName="VL_TITULO" Caption="Valor" Width="110px"&gt;
            &lt;PropertiesTextEdit DisplayFormatString="c"&gt;
            &lt;/PropertiesTextEdit&gt;
          &lt;/dx:GridViewDataTextColumn&gt;
          &lt;dx:GridViewDataTextColumn FieldName="VL_PAGO" Caption="Valor Pago" Width="110px"&gt;
            &lt;PropertiesTextEdit DisplayFormatString="c"&gt;
            &lt;/PropertiesTextEdit&gt;
          &lt;/dx:GridViewDataTextColumn&gt;
          &lt;dx:GridViewDataTextColumn FieldName="VL_SALDO" Caption="Valor Saldo" Width="110px"&gt;
            &lt;PropertiesTextEdit DisplayFormatString="c"&gt;
            &lt;/PropertiesTextEdit&gt;
          &lt;/dx:GridViewDataTextColumn&gt;
          &lt;bold&gt;&lt;dx:GridViewDataComboBoxColumn Caption="Pagamento Realizado" FieldName="CONTAS" &gt;
            &lt;PropertiesComboBox TextField="DESCRIPTION" ValueField="ID"&gt;
            &lt;/PropertiesComboBox&gt;
          &lt;/dx:GridViewDataComboBoxColumn&gt;&lt;/bold&gt;
          &lt;dx:GridViewDataTextColumn FieldName="ID_TITULO" Caption="Título"&gt;
          &lt;/dx:GridViewDataTextColumn&gt;
    &lt;/Columns&gt;
  &lt;/dx:ASPxGridView&gt;
  </code></pre>
  
  <p>`</p>
  
  <p>To fill the combo "Pagamento Realizado" I have five tables to go through filtering the data to get the accounts.
  The schema: title > movement_title &lt; financial_movement > content_movement &lt; bank_account
  Where title and financial_movement send the IDs to movement_title and so on about the ">" "&lt;" signals...
  So, I have a list with repeated Titles and repeated Accounts.
  In codebehind I can do this query (using linq) to get the specified account that correspond to the correct title:</p>
  
  <p>`</p>
  
  <pre><code>(...)
  from ti in data.FINANCEIRO_TITULOs // TITULOS
  join mt in data.FINANCEIRO_MOVIMENTOS_TITULOs on ti.NR_SEQ_TITULOS_FITI equals mt.NR_SEQ_TITULOS_FITI // MOVIMENTO_TITULOS
  join mv in data.FINANCEIRO_MOVIMENTOs on mt.NR_SEQ_MOVIMENTO_FINANCEIRO_FIMF equals mv.NR_SEQ_MOVIMENTO_FINANCEIRO_FIMF // MOVIMENTOS
  join cm in data.FINANCEIRO_CONTEUDO_MOVIMENTOs on mv.NR_SEQ_MOVIMENTO_FINANCEIRO_FIMF equals cm.NR_SEQ_MOVIMENTO_FINANCEIRO_FIMF // CONTEUDO_MOVIMENTOS
  join co in data.FINANCEIRO_CONTAs on cm.NR_SEQ_CONTAS_FICO equals co.NR_SEQ_CONTAS_FICO // CONTAS
  
  where
  ti.TP_CREDITO_DEBITO_FITI == 2 &amp;&amp; // credito
  ti.ST_SITUACAO_FITI == 3 &amp;&amp;// baixado
  ti.NR_SEQ_TITULOS_FITI.Equals(idTitulo)
  select (...)
  </code></pre>
  
  <p>`</p>
  
  <p>I need some help to do the fill.
  Please, if someone can help me, I am here to discuss...
  Thanks.</p>