Stored procedure default parameter value (Angular)link

This guide demonstrates how to set stored procedure default parameter value.

Source Code

Step by steplink

1. Create new application with .NET server-side project and add new MSSQL data-source connected to Northwind database and check stored procedures.

Stored procedures execution can be customized using partial classes and methods.

2. Create CustOrderHistsController partial class, provide default value for CustomerID parameter and filter the result. Set default value for parameters

public partial class CustOrderHistsController
{
    partial void OnCustOrderHistsDefaultParams(ref string CustomerID)
    {
        CustomerID = "AROUT";
    }

    partial void OnCustOrderHistsInvoke(ref IQueryable<CustOrderHist> items)
    {
        items = items.Where(i => i.Total > 25);
    }
}

Public Partial Class CustOrderHistsController
    Private Partial Sub OnCustOrderHistsDefaultParams(ByRef CustomerID As String)
        CustomerID = "AROUT"
    End Sub

    Private Partial Sub OnCustOrderHistsInvoke(ByRef items As IQueryable(Of CustOrderHist))
        items = items.Where(Function(i) i.Total > 25)
    End Sub
End Class

3. Invoke getCustOrderHists on button click without parameter and bind DataGrid to result.

4. Run the application