How to execute a Sql Function

M

Marco Roberto

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Call stored procedure in SSMS from Access 2016 doesn't work. 0
Execute SQL sentence 3
Getting data as returned from SQL Server 6
SQL statement under the covers 7
How To Execute A Sql Script File From ADO.NET Using VB.NET 2
remove space 2
ADO.NET Timout 9
execute a dts package from vb.net 2

Top