Hi All !

I want to use the returned value of user defined function of source code(VB.NET) in Databases( MSSQL)
is it possible to throw the returned value of user defined function of source code into databases?


Kindly Help me in this regrads plzzzz ... its really very urgent !


Regards,
Saman

You can deal with UDF from VB.NET as you use it in SQL Server, ADO.NET helps you, but please tell me do you want to pass parameters to UDF or return the value of UDF.

thnxx for consideration !

basically i have created a udf in my source file and i want to throw the returned value from that udf to database where i have created a stored procedure , in that stored procedure i want to use this returned value !

regards,
saman

If you want to create UDF in source code and save this UDF in your SQL Server, just use SMO library to help you regards this.

To add reference to SMO
Project->Add reference->Microsoft.SqlServer.Smo

thnxxx a lot

Excellent Solution !

Will distrub u again :)

regards, saman

You're welcome my friend, hope your project handed soon. we're here for help

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.