I have seen this post and paste this code as it is. actualy i have to save value in another table and combogrid values will be comes from another table but right now the combogrid is empty dont know what to do now....

<table id="dgsv_admin" title="WORKSHEET" style="width:950px; height:460px;"
         toolbar="#toolbar" pagination="false" idField="id"
         rownumbers="false" fitColumns="false" singleSelect="true">
   
      <thead>
         <tr>
            <th field="code" width="62" editor="{type:'combogrid',options:{required:true,url:'<?php echo base_url('index.php/adminworksheetscontroller/get_master_material')?>'}}">Code</th>
            <th field="type" width="64" editor="{type:'validatebox',options:{required:true}}">Type</th>
            <th field="room" width="61" editor="{type:'numberbox',options:{required:true}}">Room</th>
            <th field="length" width="61" editor="{type:'numberbox',options:{required:true}}">Length</th>
            <th field="type" width="61" editor="{type:'numberbox',options:{required:true}}">Depth</th>
         </tr>
           </thead>
</table>



<script type="text/javascript">
   $(function(){
      $('#dgsv_admin').edatagrid({
            url:'<?php echo base_url('index.php/adminworksheetscontroller/get_worksheet_stone_data')?>',
         });
   });
</script>

1-The Database table name is master_materials.There are six columns in that databse right now.
2-I want to add combogrid to the first cell of the Edatagrid.
4-The combogrid should only show one colum of the Database that is master_codes.
5-When the code is selected in combogrid I want to autopopulate the Length and Depth cells of the edatagrid from the Database other two columns(length and Depth) respective to that code.
6-Then I have to save the values in other table after the further calculation.

Hi!
I have a button and i want to add 10 Blank rows in the edatagrid. right now the code that i m using add only one row.

<table id="dgsv_admin" title="WORKSHEET" style="width:950px; height:460px;"
         toolbar="#toolbar" pagination="false" idField="id"
         rownumbers="false" fitColumns="false" singleSelect="true">
   
      <thead>
         <tr>
            <th field="code" width="62" editor="{type:'validatebox',options:{required:true}}">Code</th>
            <th field="type" width="64" editor="{type:'validatebox',options:{required:true}}">Type</th>
                         </tr>
               </thead>
</table>

Here is the code to add Rows to the above grid:

<button class="btn btn-success" onClick="javascript:$('#dgsv_admin').edatagrid('addRow')">ADD 10 ROWS</button>

Any solution regarding this....?

Thanks  Its working perfectly.

Hi!
I have seen prefix can be used in the input box for using currency signs but how to use it in edatagrid cell I dont know. I have a column two with the price filed. I want that when the values from db come they should be displayed as 7.89$ and when these values are saved to db than only 7.89 should be passed

The edatagrid code is :

<table id="dg_userspecific_stoneVariable" title="WORKSHEET" style="width:791px; height:427px;"
         toolbar="#toolbar" pagination="false" idField="id"
         rownumbers="false" fitColumns="false" singleSelect="true">
   
      <thead>
         <tr>
            <th width="630" field="name"></th>
            <th width="157" field="price" editor="{type:'numberbox',options:{precision:2}}"></th>
            
         </tr>
      </thead>
   </table>

I want to use the $ with the field price. Kindly tell me i am stuck dont know how to do...??

Hi!
I want to use combogrid in one cell of edatagrid and want to populate three fields of the edatagrid.