title: Calling SQL Defined function in C#
body: <p>I have written this scalar function in TSQL:</p>
  
  <pre><code>create function TCupom (@cupom int)
  returns float
  as
  begin
      declare @Tcu float;
  
      select @Tcu = sum (total) from alteraca2 where pedido = @cupom 
  
      if (@tcu is  null)
          set @tcu = 0;
  
      return @tcu;
  end
  </code></pre>
  
  <p>I want to call this function in my C# code. Here's what I have so far:</p>
  
  <pre><code>public void TotalCupom(int cupom)
  { 
      float SAIDA;           
      SqlDataAdapter da2 = new SqlDataAdapter();
  
      if (conex1.State == ConnectionState.Closed)
      { 
          conex1.Open();
      }
  
      SqlCommand Totalf = new SqlCommand("Tcupom", conex1);
      SqlParameter code1 = new SqlParameter("@code", SqlDbType.Int);
      code1.Value = cupom ;
      Totalf.CommandType = CommandType.StoredProcedure ;
      SAIDA = Totalf.ExecuteScalar();
  
      return SAIDA;
  }
  </code></pre>