Create View on MS SQL-Server 2005 with C#

[Karsten]

Hi,

I want to create dynamic reports with C# and MS SQL-Server 2005
Reporting Services.
Since the reporting service uses a data-table or data-view, I want to
create a view dynamically.

How can I create a data-view on a MS SQL-Server 2005 with C#?

Thanks for your help!
Karsten

 

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

You can send a CREATE VIEW with the needed fields , you have to see how
you select the naming to avoid conflicting between two running isntances of
your app. also you should remove the view after you are done with it.

No idea if Reporting Services provide something for this escenario though

 

[Karsten]

Hi,

thanks for your answer!
The question is, how do I send a CREATE VIEW to the database?
Do you have some code?

Karsten