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!
Go to Top of Page

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
Go to Top of Page
   

- Advertisement -