$column->HeaderText = "Status"; $column->AddItem("In Process"); $column->AddItem("On Hold"); $column->AddItem("Disputed"); $column->AddItem("Cancelled"); $column->AddItem("Resolved"); $column->AddItem("Shipped"); $grid->MasterTable->AddColumn($column); $column = new GridTextAreaColumn(); $column->DataField = "comments"; $column->HeaderText = "Comments"; $column->Width = "200px"; $grid->MasterTable->AddColumn($column); $column = new GridEditDeleteColumn(); $column->ShowDeleteButton = false; $column->Align = "center"; $grid->MasterTable->AddColumn($column); //Set edit mode to "form" $grid->MasterTable->EditSettings->Mode = "form"; $grid->Process(); ?> <form id="form1" method="post"> <?php echo $koolajax->Render(); ?> <?php echo $grid->Render(); ?> </form>
$grid_order->AjaxLoadingImage = $KoolControlsFolder."/KoolAjax/loading/5.gif"; $grid_order->MasterTable->DataSource = $ds_order; $grid_order->MasterTable->AutoGenerateColumns = true; $grid_order->MasterTable->Pager = new GridPrevNextAndNumericPager(); $grid_order->Process(); ?> <form id="form1" method="post"> <?php echo $koolajax->Render();?> <script type="text/javascript"> function Handle_OnRowSelect(sender,args) { //Prepare to refresh the grid_order. var _row = args["Row"]; grid_order.attachData("customer_selected",1); grid_order.attachData("customerNumber",_row.getDataItem()["customerNumber"]); grid_order.refresh(); grid_order.commit(); } </script> <div style="margin-top:10px;font-weight:bold;">Customers:</div> <?php echo $grid_customer->Render();?> <div style="margin-top:10px;font-weight:bold;">Orders:</div> <?php echo $grid_order->Render();?> </form>
$ds->UpdateCommand = "update customers set customerNumber=@customerNumber, customerName='@customerName', phone='@phone', city='@city' where customerNumber=@pk"; $ds->DeleteCommand = "delete from customers where customerNumber=@pk"; $ds->InsertCommand = "insert into customers (customerNumber,customerName,phone,city) values (@customerNumber,'@customerName','@phone','@city');"; $grid = new KoolGrid("grid"); $grid->scriptFolder = $KoolControlsFolder."/KoolGrid"; $grid->styleFolder="default"; $grid->DataSource = $ds; $grid->Width = "655px"; $grid->AllowEditing = true; $grid->AllowDeleting = true; $grid->AjaxEnabled = true; $grid->AutoGenerateRowSelectColumn = true; $grid->AutoGenerateColumns = true; $grid->DisableAutoGenerateDataFields = "pk"; $grid->AutoGenerateDeleteColumn = true; $grid->AutoGenerateEditColumn = true; $grid->MasterTable->Pager = new GridPrevNextAndNumericPager(); $grid->Process(); ?> <form id="form1" method="post"> <?php echo $koolajax->Render();?> <?php echo $grid->Render();?> </form>
$grid_order->Process(); ?> <form id="form1" method="post"> <?php echo $koolajax->Render(); ?> <script type="text/javascript"> function Handle_OnRowSelect(sender,args) { //Prepare to refresh the grid_order. var _row = args["Row"]; grid_order.attachData("customer_selected",1); grid_order.attachData("customerNumber",_row.getDataItem()["customerNumber"]); grid_order.refresh(); grid_order.commit(); } </script> <div style="margin-top:10px;font-weight:bold;">Customers:</div> <?php echo $grid_customer->Render(); ?> <div style="margin-top:10px;font-weight:bold;">Orders:</div> <?php echo $grid_order->Render(); ?> </form>