Re: How to retrieve a returned SQL function value?
From: Italo Silveira (No_at_Spam.com)
Date: 02/11/05
- Next message: abefuzzleduser2_at_yahoo.com: "Severe Error selecting ntext using sproc vb.net"
- Previous message: John Feltzer: "Pushing values back to DB from a formatted cell"
- In reply to: Andrew: "How to retrieve a returned SQL function value?"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 11 Feb 2005 17:10:51 -0500
You can use SqlCommand to execute a T-SQL to return the value.
Example:
SELECT ColName = dbo.Function(Arg)
"Andrew" <Andrew@discussions.microsoft.com> wrote in message
news:DDCCBE1B-6FFA-4C37-BD0F-94D90D210B23@microsoft.com...
> Hello, friends,
>
> There is a function in SQL Server 2000, which return a number. How can I
> retrieve this value in my C#.net app using ADO.net? Any sample source
> code?
>
> Thanks a lot.
- Next message: abefuzzleduser2_at_yahoo.com: "Severe Error selecting ntext using sproc vb.net"
- Previous message: John Feltzer: "Pushing values back to DB from a formatted cell"
- In reply to: Andrew: "How to retrieve a returned SQL function value?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
