Stored Procedure not running in VIstual Studio Query Designer

Question

Visual Studio: 2017 Shell Integrated
SQL Server 2016 Standard

Problem: In Dataset Properties ---> Select Stored Procedure --> Query Designer---> When I try to run stored procedure, I only get the column names, but no output. Please see screenshot below.

In Dataset Source, I am able to Test Connection to that Database successfully. I am also able to run that Stored Procedure in SSMS successfully.

Thanks for your help.

Answer 1

I was able to resolve this issue. I was missing a Stored Procedure, after I added missing SP, it started working.

Thanks.