Connecting to MsSQL Stored Procedures using code

2022-11-28

Connecting to MsSQL Stored Procedures using code

We continue to develop new FastReport .NET functions. Our team is increasingly expanding the features of our library for generating reports. With a recent update, we have added the function of connecting to MsSQL stored procedures. These stored procedures are a set of instructions that are executed simultaneously. Thus, the stored procedures allow you to streamline complex operations and bring them into a single object.

Previously, you could only connect to them via a database query. Now it is enough to use the standard scheme for connecting to database tables.

List of tables and stored procedures

 

Procedure icons will be different. Also, if the procedure has input parameters, a window with its parameters will appear when it is selected. In this window, you need to set parameter values if necessary. If you use the default values, then leave the Expression and Value fields empty.

Procedure parameter editor

 

If the procedure returns output parameters, then they will appear in the “Report Parameters” after creating the connection. Such parameters will be updated only when the information is uploaded into the data source.

 

Calling the procedure from code:

// Create the MsSqlDataConnection object
var connection = new MsSqlDataConnection();
// Set the connection string
connection.ConnectionString = @"Data Source=DESKTOP-43LGTAI;AttachDbFilename=; Initial Catalog=EmployeeCaseStudy;Integrated Security=True;Persist Security Info=False;User ID=;Password=";
// Initialize all tables
connection.CreateAllTables();
// Set the connection name
connection.Name = "NewConnection";
// Create a Report Object
var report = new Report();
// Add the connection to a report
report.Dictionary.Connections.Add(connection);
// Enable connection display
connection.Enabled = true;
// Select a table and connect it to the report
foreach (TableDataSource table in connection.Tables)
{
 if (table.Name == "sp_GetUser") 
 {
 foreach (CommandParameter parameter in table.Parameters)
 if (parameter.Name == "@id")
 parameter.Value = 1;
 table.Enabled = true;
 }
}

You can find procedures in the list of tables by comparing them with ProcedureDataSource.

Now it will be faster and easier for FastReport .NET users to use pre-prepared data select scripts in several reports.

.NET FastReport Data Source Stored procedures
October 13, 2025

How to Use Excel Formulas in a Report When Exporting to MS Excel

Starting with version FastReport .NET 2026.1, it is now possible to export formulas to Microsoft Excel. It is important to set up formula exports correctly and follow the syntax.
September 30, 2025

How to Install the FastReport .NET Report Designer with Pre-installed Plugins

Read the article as from version 2025.2.5 for FastReport .NET WinForms and FastReport .NET WEB allows you to install a report designer with all plugins without building dll files.
September 23, 2025

How to Export a Report to JPEG / PNG / BMP / GIF / TIFF / EMF from FastReport .NET

In this article, we will look at how to easily and efficiently export reports from FastReport .NET in JPEG, PNG, BMP, GIF, TIFF and EMF.

© 1998-2025 Fast Reports Inc.