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
Jump to PostYou 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.
Jump to PostIf 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
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
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.