Industrial Dashboard & Dojox.DataGrid Example with Oracle Connection

In this example, the javascript code needed to invoke the stored procedure dbo.getCitiesListTR(CountryID) is:

    
    attachDomReadyEventHandler(function () {
        var ConnectionParams = new ConnectionParameters('Oracle');
        ConnectionParams.add('CountryID', 'Decimal', 1);
        var options = { 'URL': '../../../DALService.svc/CallProcedure', 'DatabaseConnectionParams': { 'Engine': 'Oracle',
        'ConnectionStringName': 'OracleTest', 'Procedure': 'Scott.pcGetCitiesList.spGetCitiesList', 'TablesCount': 1} };
        dojoGrid = new DojoGrid(document.getElementById('dojoGridContainer'), options);
        dojoGrid.RefreshData(ConnectionParams);
    });
    

And this would be the callback of the onChange event in the comboBox

    function refreshData(e) {  
        var target = e || window.event.srcElement;        
        var value = target[target.selectedIndex].value;
        var ConnectionParams = new ConnectionParameters('Oracle');
        ConnectionParams.add('CountryID', 'Decimal', value);
        dojoGrid.RefreshData(ConnectionParams);
    };