PC Review


Reply
Thread Tools Rate Thread

How to execute a Sql Function

 
 
Marco Roberto
Guest
Posts: n/a
 
      15th Mar 2004
Hi,

how can I execute a Sql Function with ado.net?
The function name is "db.dbo.fn_get_max_date" and
it has not any parameter.

Regards,

Marco


 
Reply With Quote
 
 
 
 
=?Utf-8?B?U3VyZXNo?=
Guest
Posts: n/a
 
      16th Mar 2004
SqlCommand objCmd = new SqlCommand("select db.dbo.fn_get_max_date()", sqlconnection)

sqlconnection.Open()
Response.Write((string) objCmd.ExecuteScalar())
sqlconnection.Close()

Suresh

----- Marco Roberto wrote: ----

Hi

how can I execute a Sql Function with ado.net
The function name is "db.dbo.fn_get_max_date" an
it has not any parameter

Regards

Marc



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cannot get vba function to execute Donal McWeeney Microsoft Excel Programming 3 31st Jan 2007 12:13 PM
re-execute vba function Nader Microsoft Excel Programming 3 7th Jun 2006 08:21 PM
Execute function Byron Hopp Microsoft VB .NET 3 22nd Feb 2005 06:16 PM
VBA new function doesn't execute palasick Microsoft Excel Programming 0 1st Oct 2004 08:04 PM
Javascript function works but C# function doesn't execute Jim Hammond Microsoft ASP .NET 2 14th Nov 2003 09:43 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:17 PM.