calling udf from sqlhelper

[chris123321]

Can I use the SqlHelper to call a udf?

Or is there another way to call an udf in sql Server?

From doing a little research I found out that udfs are only part of SQL Server and VB.NET cannot call udfs. Just wanted to validate that.

Thanks.

 

[onpnt]

you can call the udf through a command. If the udf does not return a value just use a ExecuteNonQuery. If it doesn't look into ExecuteScalar method

_{____________ signature below ______________
The worst mistake you'll ever make is to do something simply the way you know how while ignoring the way it should be done}

 

[chris123321]

Is this a good example:

SqlConnection conn = new SqlConnection("context connection=true");
conn.Open();
SqlCommand cmd = conn.CreateCommand();

// 1. this is a user-defined function
// returning a single value (authorname) as VARCHAR
cmd.CommandText = "GetFullAuthorNameById";
// required from procedure or UDF
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@id", "172-32-1176");

http://www.awprofessional.com/articles/article.asp?p=473457&seqNum=5&rl=1

Thanks.

 

[chris123321]

SqlConnection conn = new SqlConnection("context connection=true");
conn.Open();
SqlCommand cmd = conn.CreateCommand();

// 1. this is a user-defined function
// returning a single value (authorname) as VARCHAR
cmd.CommandText = "GetFullAuthorNameById";
// required from procedure or UDF
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@id", "172-32-1176");

String fullname = (String)cmd.ExecuteScalar();
// use fullname
cmd.Parameters.Clear();

 

[onpnt]

You know this is not the C# forum right?

_{____________ signature below ______________
The worst mistake you'll ever make is to do something simply the way you know how while ignoring the way it should be done}

 

[chris123321]

Yes, but the example I found was in C#..