Retrieve return value of SQL User Defined Function?

[Mark B]

I have been able to retrieve the scalar value of a SQL Server Stored
Procedure as follows:

Shared Function fGetGroupPerfor manceStatistic( ByVal strGroup As String) As
String

Dim sqlConnection1 As New SqlConnection(" Data
Source=MARK\SQL EXPRESS;Initial Catalog=GroupSa les;Integrated
Security=True;" )
Dim cmd As New SqlCommand

cmd.CommandText = "ufWebStatsAver ageSalesGroup"
cmd.CommandType = Data.CommandTyp e.StoredProcedu re
cmd.Connection = sqlConnection1
sqlConnection1. Open()
cmd.Parameters. Add(New SqlParameter("@ EnterGroup", strGroup))
fGetGroupPerfor manceStatistic = cmd.ExecuteScal ar()
sqlConnection1. Close()

End Function
Now I want to retrieve the value from an SQL Server User Defined Function
udf.GetTopSales Figure(@EnterGr oup nvarchar(50))

How would I do that in VB code similar to the code above?

Also, can I do it by just dragging an SQLDataSource control onto the aspx
page and referencing that?

[Munna]

On Jun 9, 11:42 am, "Mark B" <[e-mail] rote:

I have been able to retrieve the scalar value of a SQL Server Stored
Procedure as follows:

Shared Function fGetGroupPerfor manceStatistic( ByVal strGroup As String) As
String

Dim sqlConnection1 As New SqlConnection(" Data
Source=MARK\SQL EXPRESS;Initial Catalog=GroupSa les;Integrated
Security=True;" )
Dim cmd As New SqlCommand

cmd.CommandText = "ufWebStatsAver ageSalesGroup"
cmd.CommandType = Data.CommandTyp e.StoredProcedu re
cmd.Connection = sqlConnection1
sqlConnection1. Open()
cmd.Parameters. Add(New SqlParameter("@ EnterGroup", strGroup))
fGetGroupPerfor manceStatistic = cmd.ExecuteScal ar()
sqlConnection1. Close()

End Function

Now I want to retrieve the value from an SQL Server User Defined Function
udf.GetTopSales Figure(@EnterGr oup nvarchar(50))

How would I do that in VB code similar to the code above?

Also, can I do it by just dragging an SQLDataSource control onto the aspx
page and referencing that?

Hi

follow this thread...

http://forums.devx.com/showthread.php?t=146418

call function in store procedure call the store procedure from asp.net

Best of luck

Munna
www.munna.shatkotha.com
www.munna.shatkotha.com/blog
www.shatkotha.com

[siccolo]

if you have a function GetTopSalesFigu re(<some paremeters>), then in
your stored proc

create stored procedure fGetGroupPerfor manceStatistic
(
....your parameters...
)
as
select dbo. GetTopSalesFigu re(<some paremeters>) as
test_function_r esult

.... more articles at http://www.siccolo.com/articles.asp