C # Call the return values of SQL udfs

1 -- SQL UDF:
2
3 create function [GetProjectID] (@ headStr nvarchar (10), @ date datetime)
4)
5
6 returns nvarchar (200)
7
8
9
10 BEGIN
11
12 -- insert into cannot be used in user-defined functions
13
14 -- insert into emos_cust (cust_name, dates) values (
15
16 -- @ headStr, @ date
17
18 --)
19
20 return TEST BY HANSHU
21 END

Code 1 /// <summary>
2 // get the project file No. geovindu@163.com tujuwen
3 /// </summary>
4 private void FileNo ()
5 {
6
7 SqlConnection conn = new SqlConnection (connectionString );
8 string strSql = "GetProjectID"; // custom SQL function
9 SqlCommand cmd = new SqlCommand (strSql, conn );
10 cmd. CommandType = CommandType. StoredProcedure;
11 cmd. Parameters. Add ("@ headStr", SqlDbType. NVarChar). Value = "ZQ3"; // encode