title: How to display dropdown list with values in the datatable while performing inline editing?
body: <p>I need to display a dropdownlist in a particular cell while performing inline editing and need to load the values in the dropdownlist from the datatbase. I know how to load the values in the dropdownlist outside the datatable. Is this the same process while it is inside the datatable?.<br>
  Please give me some ideas to perform this task?</p>
  
  <p>This is my code, where the row that is clicked will have the textbox and the dropdownlist (without any values)</p>
  
  <pre><code>   var table = $('#jsontable').DataTable();
          $('#jsontable').DataTable().column(0).visible(false);
          $('#jsontable').DataTable().column(3).visible(false);           
          var nEditing = null;          
              $('#jsontable tbody').on('dblclick', 'tr', function () {                           
              var nRow = $('#jsontable').dataTable().fnGetNodes(this);
              d = $('#jsontable').DataTable().row(this).data();
              editRow(table, nRow);
              nEditing = nRow;
          });
   function editRow(table, nRow){          
          var jqTds = $('&gt;td', nRow);      
          jqTds[0].innerHTML = '&lt;div class="col-sm-3"&gt;&lt;select class="form-control" value: "' + d[1] + '" optionsCaption: "All"  id="channel"&gt;&lt;/select&gt;&lt;/div&gt;';          
          jqTds[1].innerHTML = '&lt;input type="text" value="' + d[2] + '"&gt;';
          jqTds[2].innerHTML = '&lt;input type="text" value="' + d[4] + '"&gt;';
          jqTds[3].innerHTML = '  &lt;div class="col-sm-6" id="dt-container" data-bind="validationElement: locationEffcetivefromdate"&gt;&lt;div class="input-append input-group date"&gt; &lt;input type="text" value="' + d[5] + '"&gt;&lt;span class="input-group-addon"&gt;&lt;i class="fa fa-calendar"&gt;&lt;/i&gt;&lt;/span&gt;&lt;/div&gt;&lt;/div&gt;';          
              }
  </code></pre>
  
  <p>This is my html code for the table,</p>
  
  <pre><code>&lt;div id="locationtable" class="ibox-content"&gt;
  
                      &lt;table id="jsontable" class="table table-striped table-bordered table-hover dataTables-example" style="width:100%"&gt;
                          &lt;thead&gt;
                              &lt;tr&gt;
                                  &lt;th style="visibility:hidden"&gt;ID&lt;/th&gt;
                                  &lt;th&gt;Name&lt;/th&gt;
                                  &lt;th&gt;Age&lt;/th&gt;
                                  &lt;th style="visibility:hidden"&gt;Address&lt;/th&gt;
                                  &lt;th&gt;Effective From&lt;/th&gt;
                                  &lt;th&gt;Effective To&lt;/th&gt;
                              &lt;/tr&gt;
                          &lt;/thead&gt;
                      &lt;/table&gt;
                  &lt;/div&gt;
  </code></pre>