How to call SQL Function from vb.net

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

Dec 12 '07 #1

Subscribe Post Reply

18592

=?Utf-8?B?S2VycnkgTW9vcm1hbg==?=

Harsha,

http://support.microsoft.com/kb/329497

Kerry Moorman
"Harsha" wrote:

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

Dec 12 '07 #2

zacks

On Dec 12, 8:23 am, Harsha <sriharsha.ga...@gmail.comwrote:

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

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.

Dec 12 '07 #3

Similar topics

Call Function

by: Lucy Randles | last post by:

I've written a VBA function that I then need to call in a form. Previously to do this I have written the call procedure in the same module as the function - i.e. Function callfunctionname() Call...

Microsoft Access / VBA

Call function

by: PawelR | last post by:

Hello Group, In my application I have few class, and I want call function with "master class". This is as master form (startClass) and option window (ClassA). My question is how call function...

C# / C Sharp

call function from class

by: Dave | last post by:

I have a program that I've written a class for. I need to call the function in the program from the class. When I try to call the function I receive the error, the name xxx does not exist in the...

C# / C Sharp

Call function in codebehind from jscript in aspx page

by: moondaddy | last post by:

I'm using vb.net and have an aspx page where I want to call a function in the code behind to do something on the backend and I want to call this function from a jscript function in the aspx page. ...

ASP.NET

How To Call Function ...

by: Tiraman | last post by:

Hi , I have 3 files , middle.aspx file include the header.aspx and footer.aspx files . in each of the include files there is a function and from some reason the call to the Footer() function...

ASP.NET

Call function at runtime

by: leaf | last post by:

Hi, How to call function at runtime, based on a struct that contains the information for the function call: struct func_to_call { int function_id; // function id to call unsigned int nparams;...

C / C++

How do I call function that a variable refers to?

by: yaru22 | last post by:

Hi. I'm wondering if there is a way to call function that a variable refers to. I was writing a script to load xml file. And what I've written so far looks like this: var xmlDoc; ...

Javascript

How can function A call function B with the same argument list?

by: Khai Doan | last post by:

I have function A, which need to call function B with the exact same argument list. What is the correct way to do this? I had function A: function A { B(arguments); } but it does not...

Javascript

call function from within another

by: Andrew Poulos | last post by:

Say I have this: var foo = function(x, y) { return x + y; }; var bar = function(fname, param1, param2) { /* * how do I call the function "foo" * and pass parameters to it?

Javascript

how to call function php($varible) into javascript withod ajax

by: intermanch | last post by:

how call function php($varible) into javascript withod ajax: <!-- this code only call funnctions php but how call function php intermanch@gmail.com www.intermanch.blogfa.com

PHP

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing