How to get the result of a stored procedure with parameters in C#?

See more:

C#

SQL-Server

dataset

, +

I have the following stored procedure with parameters:

USE [DBRapBreaza]
   GO
   /****** Object:  StoredProcedure [dbo].[PS_SpauOPompa]    Script Date: 1/10/2019 10:01:13 ******/
   SET ANSI_NULLS ON
   GO
   SET QUOTED_IDENTIFIER ON
   GO

   ALTER PROCEDURE [dbo].[PS_SpauOPompa]

   @DataStart datetime,
   @DataStop datetime,
   @val int
   AS
   BEGIN
   SET NOCOUNT ON;

   declare @sql NVARCHAR(max)
   declare @col1 varchar (25)
   declare @col2 varchar(25)
   declare @col3 varchar (25)
   declare @col4 varchar (25)
   declare @col5 varchar (25)
   declare @col6 varchar (25)

   set @col1='ID'
   set @col2='BREAZA_SPAU'+CONVERT(VARCHAR, @val)+'_EA'
   set @col3='BREAZA_SPAU'+CONVERT(VARCHAR, @val)+'_EQ'
   set @col4='BREAZA_SPAU'+CONVERT(VARCHAR, @val)+'_ore1'
   set @col5='BREAZA_SPAU'+CONVERT(VARCHAR, @val)+'_nivel'
   set @col6='DateTime'

   set @sql= 'select [ID], ' + @col2 + ',' + @col3 + ',' + @col4 + ',' + @col5 + ',' + @col6 + ' FROM [DBRapBreaza].[dbo].[TblSPAU'+CONVERT(VARCHAR, @val)+ '] WHERE DateTime between '''+CONVERT(VARCHAR(25), @DataStart,121)+ ''' and '''+CONVERT(VARCHAR(25), @DataStop,121)+''';'

   print @sql;


   EXEC sp_executesql
       @sql,
       N'@DataStart datetime, @DataStop datetime, @val int',
       @DataStart, @DataStop, @val;
   END
 --execute [PS_SpauOPompa] '2018-12-13 15:58:46.940', '2018-12-13 16:31:39.243', 40

When I execute it in Microsoft SQL Server Management all is fine. The result of executing the stored procedure is:
Untitled — imgbb.com[^]
I want to get this results in C# by using DataSet item from Visual Studio. When I select the stored procedure, none of the columns is displayed in Data Column (see the below image). vs — imgbb.com[^]
What should I do so to get these columns in C#? Thanks in advance!

What I have tried:

See above the code I have done so far.