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.
| Author |
Topic |
|
Lucky
Starting Member
10 Posts |
 Posted - 2008-11-24 : 19:30:53
|
| Hi Dears,I am getting results in view by giving Employee number in where class, but Actually I need to pass parameter value in view to get remaining information and this view I have to use in Visual Basic ? any idea ?______________________________________________________________________________________"We can be Knowledgeable with other mens Knowledge, but we can't be wise with other mens wisdom" |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-24 : 19:37:03
|
| You can't pass parameter in view. You have to use Stored procedure or Functions. |
 |
|
|
Lucky
Starting Member
10 Posts |
Posted - 2008-11-24 : 19:40:29
|
| Can I use stored procedure or funtion using view in Visual Basic to return values ?______________________________________________________________________________________"We can be Knowledgeable with other mens Knowledge, but we can't be wise with other mens wisdom" |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-24 : 23:06:08
|
quote:
Originally posted by Lucky
Can I use stored procedure or funtion using view in Visual Basic to return values ?______________________________________________________________________________________"We can be Knowledgeable with other mens Knowledge, but we can't be wise with other mens wisdom"
whats the need of view here? can you explain? Cant you simply use SP or function? |
|
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2008-11-25 : 00:09:08
|
quote:
Originally posted by Lucky
Can I use stored procedure or funtion using view in Visual Basic to return values ?______________________________________________________________________________________"We can be Knowledgeable with other mens Knowledge, but we can't be wise with other mens wisdom"
When you use the SqlCommand class in Visual Basic .NET you can set the CommandType to StoredProcedure to execute stored procedures (it defaults to Text, which you'd use with SQL statements). |
|
|
|
|
|
|
Pass Parameter in VIEW !