调用SQL Server中的函数

SqlConnection conn = new SqlConnection(conn_string);

SqlCommand cmd = new SqlCommand("dbo.Week2DayFun", conn);//调用函数

cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@s", SqlDbType.VarChar).Value = aResult.datecode;//Week2DayFun中需传入的参数
cmd.Parameters.Add("@Result", SqlDbType.VarChar).Direction = ParameterDirection.ReturnValue;

if (conn.State != System.Data.ConnectionState.Open)
conn.Open();

cmd.ExecuteNonQuery();
string ss = cmd.Parameters["@Result"].Value.ToString();//查询的结果

conn.Close();