471,316 Members | 1,531 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,316 software developers and data experts.

Create View on MS SQL-Server 2005 with C#

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

Jan 19 '06 #1
2 3649
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
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Karsten" <kb******@gmail.com> wrote in message
news:11**********************@g49g2000cwa.googlegr oups.com...
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

Jan 19 '06 #2
Hi,

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

Karsten

Jan 19 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by js | last post: by
3 posts views Thread by M. Mehta | last post: by
2 posts views Thread by Not Me | last post: by
7 posts views Thread by kackson | last post: by
1 post views Thread by Muhyiddin A.M Hayat | last post: by
2 posts views Thread by Shirley | last post: by
2 posts views Thread by db55 | last post: by
reply views Thread by rosydwin | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.