Hi.

I am using the following SQLHelper code:

http://www.sharpdeveloper.net/source...e-Code-cs.html

I am trying to use a Sql Function to return a dataset and
I simply don't know how to do this using SqlHelper. I
am giving text or stored procedure as options.

Has anybody out there used this class to call a Sql function?

Thanks.

pbd22 (dushkin (AT) gmail (DOT) com) writes:
I've never this class before, and I guess you may get better help in a
..Net forum.

Then again, calling a function, is just like running any other SELECT:

SELECT col1, col2, col3
FROM my_func(@param1, @param2)


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx