How to retrieve the returned function value?

[Guest]

Hi, friends,

I need to call a function of SQL Server 2000. I tried to use
DataSet.SelectCommand by passing a stored procedure command, and then fill
the dataset. This works fine with store procedures that return record sets.
But failed this time. What is correct way to do this? Thanks a lot

 

[Patrice]

What do you you do exactly ?

I would try SELECT * FROM MyFunction() instead of calling the function as a
stored procedure...

Patrice

 

[Sahil Malik]

But failed this time.

--- Okay what exactly did you do in "this" time? Specifically what was your
commandtext, connectionstring, and error?

- Sahil Malik
http://codebetter.com/blogs/sahil.malik/

 

[Guest]

I wrap it in SQL like so:
Select dbo.MyFunction('arg1','arg2')
Note that I could also run this line in Query Analyzer.

I then execute the SQL and store the results as a DataTable (if the function
returned data). I built a method in our DataLayer to make this easier:
DataTable ExecuteSql(string strSqL) {...}


Tim
http://timstall.dotnetdevelopersjournal.com/