Calling SQL Defined function in C#

by

You can’t just call the function name, you will need to write an inline SQL statement which makes use of the UDF:

SqlCommand Totalf = new SqlCommand("SELECT dbo.Tcupom(@code)", conex1);

And remove the CommandType, this isn’t a Stored Procedure, its a User Defined Function.

In all:

public void TotalCupom(int cupom)
{ 
    float SAIDA;           
    SqlDataAdapter da2 = new SqlDataAdapter();
    if (conex1.State == ConnectionState.Closed)
    {
        conex1.Open();
    }
    SqlCommand Totalf = new SqlCommand("SELECT dbo.Tcupom(@code)", conex1);
    SqlParameter code1 = new SqlParameter("@code", SqlDbType.Int);
    code1.Value = cupom;
    SAIDA = Totalf.ExecuteScalar();

    return SAIDA;
}

More Related Contents:

  1. Taking lot of time to read from SQL Server using c#
  2. I want to insert a record in DB and then need to return a row
  3. How do I clean SqlDependency from SQL Server memory?
  4. Adding multiple parameterized variables to a database in c#
  5. How do I connect to an MDF database file?
  6. SQL WHERE clause matching values with trailing spaces
  7. When is it better to write “ad hoc sql” vs stored procedures [duplicate]
  8. Passing datatable to a stored procedure
  9. Search SQL by date ASP.NET
  10. How can I add user-supplied input to an SQL statement?
  11. How to get last inserted id?
  12. What is the syntax for an inner join in LINQ to SQL?
  13. The type or namespace name could not be found [duplicate]
  14. LINQ to Entities does not recognize the method ‘System.String ToString()’ method, and this method cannot be translated into a store expression
  15. two different DLL with same namespace
  16. Encrypt connection string in app.config
  17. Dependent DLL is not getting copied to the build output folder in Visual Studio
  18. How can I log the generated SQL from DbContext.SaveChanges() in my Program? [duplicate]
  19. Setting the datasource for a Local Report – .NET & Report Viewer
  20. Can you use optional parameters in code targeting .NET 3.5?
  21. get date part only from datetime value using entity framework
  22. ASP.NET ODBC Query with parameters
  23. The variable name ‘@’ has already been declared. Variable names must be unique within a query batch or stored procedure
  24. Does not contain a static ‘main’ method suitable for an entry point
  25. streamWriter rewrite the file or append to the file
  26. Writing custom code for PowerPoint using leap motion?
  27. Generating sql code programmatically
  28. Click an HTML link inside a WebBrowser Control
  29. Prevent Winforms Designer from Generating Property Values for Inherited Controls
  30. Do we have transactions in MS-Access?

Leave a Comment