How to retrieve a returned SQL function value?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You can use SqlCommand to execute a T-SQL to return the value.

Example:

SELECT ColName = dbo.Function(Arg)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to access an SQL function via .NET DataAdapter? 3
Retrieving SQL SP Output Parameters 2
error numbers which can be generated by ADO.Net (Not SQL Server) 4
How to retrieve all sql server errors on ADO.NET? 4
Dinamically retrieve existing relations in a database 0
VBA - retrieve data on last create named range from previous inserted named range 0
Getting data as returned from SQL Server 6
Retrieve Image stored in SQL Server Table Column 1

Back
Top