Using stored procedures to generate RDLC report in C#
- by NDraskovic
I'm making an application that generates reports for my client. I'm using his database that contains stored procedures which return the data needed for the reports. The problem is that I don't know how to execute them from the application (more specific the TableAdapter in my dataset). When I use the visual aid to create the TableAdapter, it shows the error "Invalid object named #table1". This is weird because there is a temporary table called #table1 in the stored procedure.
When I try to do the whole job programmatically, I get the exception
Incorrect syntax near '.'.
An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.
I created a DataTable that has identical structure as the result of the stored procedure, but I still get the same exception