I am now trying to use SQLSRVDataSource.php to connect to and display data using KoolGrid. When I do, the connection does not fail, but the returned page is totally blank.
At the end of this posting is the code I am using. The connection is identical to the one that is mentioned in the first sentence above.
<?php
//Step 1: Register KoolGrid component to your page
//echo "Getting required php files<br />";
require "KoolControls/KoolGrid/koolgrid.php";
require "KoolControls/KoolAjax/koolajax.php";
require "KoolControls/KoolGrid/ext/datasources/SQLSRVDataSource.php";
$koolajax->scriptFolder = "KoolControls/KoolAjax";
$serverName = "(local)\SQLEXPRESS";
// If UID and PWD are not specified in the $connectionInfo array,
// The connection will be attempted using Windows Authentication.
$connectionInfo = array( "Database"=>"AdventureWorksLT2014", "UID"=>"XXX", "PWD"=>"XXX");
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn === false )
{
echo "Unable to connect.</br>";
die( print_r( sqlsrv_errors(), true));
}
$ds = new $SQLSRVDataSource($conn);
$ds->SelectCommand = "SELECT * FROM [AdventureWorksLT2014].[SalesLT].[Customer]";
//Step 3: Init KoolGrid and settings
$grid = new KoolGrid("grid");
$grid->scriptFolder = "KoolControls/KoolGrid";
$grid->styleFolder="default";
$grid->DataSource = $ds;
$grid->AjaxEnabled = true;
$grid->Width = "655px";
$grid->AllowInserting = true;
$grid->AllowSorting = true;
$grid->AutoGenerateColumns = true;
$grid->MasterTable->Pager = new GridPrevNextAndNumericPager();
//Step 4: Process Grid
$grid->Process();
?>
<html>
<head>
<title></title>
<?php echo $koolajax->Render();?>
</head>
<body>
<form id="form1" method="post">
<!-- Step 5: Get KoolGrid render -->
<?php echo $grid->Render();?>
</form>
</body>
</html>