Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> Visual Basic >> Visual Basic Language

call a sqlserver function from vb2005

Hello. Aquestion please. Could anyone say me how can I call a sqlserver function from sqlserver ?

thanks..

[119 byte] By [NetPochi] at [2007-12-28]
«« LSP (Layered Service Provider) issue related to UAC and IE7 on Vista
»» Rehosting Designer and name change through properties grid
# 1

Use ADO.NET and the sqlCommand object.

Public NotInheritable Class SqlCommand

Inherits System.Data.Common.DbCommand

Member of: System.Data.SqlClient

Summary:

Represents a Transact-SQL statement or stored procedure to execute against a SQL Server database. This class cannot be inherited.

DMan1 at 2007-9-4 > top of Msdn Tech,Visual Basic,Visual Basic Language...
# 2

NetPochi,

It is not so clear that you want to call a SQL Server function from sqlserver. In Common Language Runtime, there are so many objects and methods or as you described functions, such as SqlConnection, the connectionString configuration for you to connect to the SQL Server databse, SqlCommand, the SQL statement for manipulating the data, DataReader and DataSet, two methods for accessing data in your database. Could you tell me your target of calling the functions for?

BrunoYu-MSFT at 2007-9-4 > top of Msdn Tech,Visual Basic,Visual Basic Language...
Visual Basic
Visual Basic Language

Visual Basic Hot Topic

Visual Basic New Topic

Visual Basic

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified