jQWidgets Forums

I have

var dataAdapter = new $.jqx.dataAdapter(source);

Isnt that enough?

here is all my code:

<?php $tabran = $timestamp = (microtime(1) * 100); ?>
<script type="text/javascript">
$(document).ready(function () {
		var theme = getDemoTheme();
        var tabran = '<?php echo $tabran; ?>'; 
		var source =
		{
			datatype: "json",
			datafields: [
				{ name: 'contactid'},
				{ name: 'fname'},
				{ name: 'lname'},
				{ name: 'tel'},
				{ name: 'email'},
				{ name: 'cp', type: 'number'},
				{ name: 'ba', type: 'number'},
				{ name: 'lang'},
			],
			url: 'sql/s1.php',
			cache: false,
			  updaterow: function (rowid, rowdata, commit) {
                    // synchronize with the server - send update command   
                    commit(true);
                }
		};
		var dataAdapter = new $.jqx.dataAdapter(source);
			
		$("#"+tabran).jqxGrid(
		{
		width: 1000,
		height:500,
		showfilterrow: true,
        filterable: true,
        groupable: true,
        columnsresize: true,
        columnsreorder: true,
        editable: true,
        showaggregates: true,
        showstatusbar: true,
        statusbarheight: 50,
        selectionmode: 'singlecell',
        showtoolbar: 'true',
		source: source,
		theme: theme,
		columns: [
			{ text: 'Voornaam', datafield: 'fname', width: 100, aggregates: ['count']},
	
			
			{ text: 'Achternaam', datafield: 'lname', width: 250, aggregates: ['count'] },
			{ text: 'Telefoon', datafield: 'tel', width: 100, aggregates: ['count'] },
			{ text: 'Email', datafield: 'email', width: 120, aggregates: ['count'] },
			{ text: 'Contact Persoon', datafield: 'cp', width: 100, aggregates: ['count'] },
			{ text: 'Bevoegd Aanvrager', datafield: 'ba', width: 100, aggregates: ['count'] },
			{ text: 'Taal', datafield: 'lang', width: 50, aggregates: ['count'] },
			
			
		]
		 
		});   
		
		$("#excelExport").jqxButton({ theme: theme });
            $("#xmlExport").jqxButton({ theme: theme });
            $("#csvExport").jqxButton({ theme: theme });
            $("#tsvExport").jqxButton({ theme: theme });
            $("#htmlExport").jqxButton({ theme: theme });
            $("#jsonExport").jqxButton({ theme: theme });
		//	var exportInfo;
            //$("#excelExport").click(function () {
            //    exportInfo = $("#"+tabran).jqxGrid('exportdata', 'xls');
            //    document.write (exportInfo);
           // });
            
            $("#excelExport").click(function () {
                $("#"+tabran).jqxGrid('exportdata', 'xls', 'jqxGrid');           
             });
            $("#xmlExport").click(function () {
                $("#"+tabran).jqxGrid('exportdata', 'xml', 'jqxGrid');
            });
            $("#csvExport").click(function () {
                $("#"+tabran).jqxGrid('exportdata', 'csv', 'jqxGrid');
            });
            $("#tsvExport").click(function () {
                $("#"+tabran).jqxGrid('exportdata', 'tsv', 'jqxGrid');
            });
            $("#htmlExport").click(function () {
                $("#"+tabran).jqxGrid('exportdata', 'html', 'jqxGrid');
            });
            $("#jsonExport").click(function () {
                $("#"+tabran).jqxGrid('exportdata', 'json', 'jqxGrid');
            });
                  
	});
	
	
</script>
	    
	    
	    <?php echo '<div id='. $tabran .'></div>' ?>
	    
	    
	        <div style='margin-top: 20px;'>
            <div style='float: left;'>
                <input type="button" value="Export to Excel" id='excelExport' />
                <br /><br />
                <input type="button" value="Export to XML" id='xmlExport' />
            </div>
            <div style='margin-left: 10px; float: left;'>
                <input type="button" value="Export to CSV" id='csvExport' />
                <br /><br />
                <input type="button" value="Export to TSV" id='tsvExport' />
            </div>
            <div style='margin-left: 10px; float: left;'>
                <input type="button" value="Export to HTML" id='htmlExport' />
                <br /><br />
                <input type="button" value="Export to JSON" id='jsonExport' />
            </div>
		</div>
        
    <script>     //prints the value of x </script>
        
        

kind Regards

Shiva