How to call SQL Function from vb.net

  • Thread starter Thread starter Harsha
  • Start date Start date
H

Harsha

Hi

PLease let me know how to call the SQL User defined function from the
VB.Net code?

I have sevaral functions in my SQL database which is created out of
database project.

I want to execute these function from VB.Net

Thanks in advance

Sriharsha Karagodu
 
Hi

PLease let me know how to call the SQL User defined function from the
VB.Net code?

I have sevaral functions in my SQL database which is created out of
database project.

I want to execute these function from VB.Net
Click to expand...

User Defined Functions aren't designed to be executed alone. They must
appear as an element in a SELECT resultset, or be the right hand side
of an UPDATE SET, or appear in a WHERE clause. There may be other
places they can appear, but those are the most common.
 
Back
Top