Stored procedure default parameter value

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

Step by step

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 NorthwindService partial class, provide default value for CustomerID parameter for OnCustOrderHistsDefaultParams method and filter the result. Set default value for parameters

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

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

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

4. Run the application

We are here for you

Making our users happy is always a priority for us.