Following is the code to add Combobox in editable data grid:
Index.html:
<table id="dg" title=” Combobox in editable datagrid ” style="width:100%;height:700px" toolbar="#toolbar" pagination="true" rownumbers="true" fitColumns="false" singleSelect="true" autoSave="true" data-options="pageSize:50"> <thead> <tr> <th field="Item_number"width="100" editor="{ Type:'combobox', Options:{url:'get_itemname.php', valueField:'itemno', textField:'itemname' }}">Item Name</th> <th field="type" width="70">Cost</th> </tr> </thead> get_itemname.php <?php $host = "localhost"; $user = "username"; $pass = "password"; $db = "database_name"; $conn = mysql_connect ( $host, $user, $pass ) or die ( "Unable to connect!" ); mysql_select_db ( $db ) or die ( "Unable to select database!" ); $getItemQuery="SELECT `itemno,itemname` FROM item"; $getItemQuery_Result=mysql_query ($getItemQuery ); $JsonData=array(); while ( $row = mysql_fetch_assoc($getItemQuery_Result) ) { $item_no = $row ['itemno']; $item_name = $row ['itemname']; $Item_obj=new Item($item_no, $item_name); array_push($JsonData, $Item_obj); } echo json_encode($JsonData); //return data back to the client in Json format class Item { public $itemno; public $itemname; function __construct($itemno,$itemName) { $this->itemno=$itemno; $this->itemname=$itemName; } }