how to call the sql server function in .net

naresh

Active member
Joined
Jul 4, 2006
Messages
38
Programming Experience
1-3
can i use the userdefined functions wrote in the sql server in vb.net. if possible please help me . suppose my function is with two parameters. let me know how the things happen ie. via sqlcommand or something other to connect to the sqlserver.
thanks in advance
Naresh
 
I am not sure if you can call them directly - but you can certainly wrap them in a stored procedure.

Can you be more specific?
 
Try this;

In SQLCommand initiation pass following Or similar SQL statement.

SELECT DBO.YOUR_FUNCTION(PARAMETER1, PARAMETER2) AS 'SOME_COLUMN_NAME'
 
Back
Top