$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>
