I have a situation in my C#.Net-Sql Program.
I want create a excel report for my new company, In the report number of columns based on some other master table condition,also master table entries should be the column headers.So pivoting of master table is needed(2 times).
So i panned things as follows ,
1)Create a stored procedure with parameters.
2)Execute the stored procedure from C# and read/store table formatted data in a C# DataTable.
3)Print the DataTable values to an Excel .
So i create a stored procedure ,when i am running it in sql server it is working fine and the a table structured output is coming as expected .
Now i tried to run it from C# , DataTable Fill results 0 rows and 0 columns.
Why this happened like this ???
I had a temporary solution, as
i altered the Procedure and tried to save the output to a dynamic table (Using select * into) . Then i check the dynamic table after the program execution ,i found the out put is saved in that dynamic table .
Then i read the data of this dynamic table using another procedure .