How to fill a dataset from an SQL user-defined function
Posted on 2004-09-03
I have an SQL inline udf which takes 3 parameters and returns a table of results. (It works in SQL query analyser so I know there's no probs on the SQL end). I'm trying to get the resulting table into a dataview:
DbCommand.CommandText = "SELECT * FROM dbo.[udfMyUDF](1,1,65)"
DbDataAdapter.SelectCommand = DbCommand
DbDataSet = New DataSet
The connection, command & adapter all seem to go through fine but when I do the fill I get 0 rows and no table. Can anyone help ?