invoking view from C# - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

.NET Inside SQL Server (2005)

invoking view from C#

Author

Topic

nagarajanit
Starting Member

1 Post

Posted - 2008-07-03 : 03:02:36

hi guys..

let anyone try to solve my problem...
i want to invoke view procedure in sqlserver2000 from C# windows application..

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-07-03 : 08:37:39

SqlCommand cmd = new SqlCommand("select * from yourView")
and then use that command to get results.

_______________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.0 out!

atulmar
Starting Member

7 Posts

Posted - 2008-07-03 : 14:10:37

I dont think he will be asking so simple question, can you give some detail. what view procedure invoking means here

Is it
1. Execute the procedure that is referencing view
2. You want to see definition for view
3. You want to fetch the data in view

Thanks
Atul

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources