how to call the sql server function in .net

[naresh]

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

 

[Gruntie776]

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?

 

[Shirish Kokate]

Try this;

In SQLCommand initiation pass following Or similar SQL statement.

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