Table of Contents

Run SQL Script when saving Worksheets or Tables

If you need to run a SQL Script when saving Worksheet or Table data, use the SqlScriptService in the Save Data | On Save Script.


Example


    // This method is called after the changes have been saved to the database.
    // The operationType specifies whether the rows was inserted, updated or deleted.

    protected override void OnAfterSave(IEnumerable<CudRecord> rows, TableOperationType operationType)
    {   
        base.OnAfterSave(rows, operationType);

        //Executes query after save has been done, returns the amount of rows affected
        this.SqlScriptService.ExecuteNonQueryById("24e871f8-cd46-4c51-9a46-cbf7eec66bff");
    }

    // This method is called at the end of the commit process.
    // The data parameters contains the rows that was deleted, updated or inserted.

    protected override void OnEndSave(CudDataPackage data)
    {
        base.OnEndSave(data);

        // When method is called returns the first value of the result set.
        var myNum = this.SqlScriptService.ExecuteScalarById<int>("63aa2021-4092-48d1-ba8f-975aeecb5202");
    }

SqlScriptService methods


ExecuteNonQueryById

Executes a SQL Script, specified by its object id, and returns the number of rows affected by the query.

public int ExecuteNonQueryById(string scriptId, Dictionary<string, object> paramValues = null)

ExecuteNonQueryByName

Executes a SQL Script, specified by its object name , and returns the number of rows affected by the query.

public int ExecuteNonQueryByName(string scriptName, Dictionary<string, object> paramValues = null)

ExecuteScalarById

Executes a SQL Script, specified by its object id, and returns the value in the first column in the first row from the result set.

Note

the SQL Script must be configured to return data.

public T ExecuteScalarById<T>(string scriptId, Dictionary<string, object> paramValues = null)

ExecuteScalarByName

Executes a SQL Script, specified by its object name, and returns the value in the first column in the first row from the result set.

Note

The SQL Script must be configured to return data.

public T ExecuteScalarByName<T>(string scriptName, Dictionary<string, object> paramValues = null)

LoadById

Executes a SQL Script, specified by its object id, and returns the data set from the query.

Note

The SQL Script must be configured to return data.

public DataTable LoadById(string scriptId, Dictionary<string, object> paramValues = null)

LoadByName

Executes a SQL Script, specified by its object Name, and returns the data set from the query.

Note

The SQL Script must be configured to return data.

public DataTable LoadByName(string scriptName, Dictionary<string, object> paramValues = null)
Edit this page