How to run the stored procedure that has OUTPUT parameter from C#?

by

I assume you use ADO.NET? If so, the SqlParameter class has the property “Direction”. Set direction to output and after the query has executed you read the value from that parameter.

Something like this:

using (SqlCommand cmd = new SqlCommand("MyStoredProcedure", cn))
{
    cmd.CommandType = CommandType.StoredProcedure;
    SqlParameter parm = new SqlParameter("@pkid", SqlDbType.Int);
    parm.Value = 1;
    parm.Direction = ParameterDirection.Input;
    cmd.Parameters.Add(parm);

    SqlParameter parm2 = new SqlParameter("@ProductName", SqlDbType.VarChar);
    parm2.Size = 50;
    parm2.Direction = ParameterDirection.Output; // This is important!
    cmd.Parameters.Add(parm2);

    cn.Open();
    cmd.ExecuteNonQuery();
    cn.Close();
}

More Related Contents:

  1. How do I put an image in VisualStudio with C#? [closed]
  2. C# Singleton Form pattern, how to run 2 and more forms? [closed]
  3. Download binary file over HTTP
  4. Retrieving Property name from lambda expression
  5. How to build a query string for a URL in C#?
  6. How to get the type of T from a member of a generic class or method
  7. ProcessStartInfo hanging on “WaitForExit”? Why?
  8. Set global hotkeys using C#
  9. What is the difference between an int and an Integer in Java and C#?
  10. Is using a ‘goto’ statement bad?
  11. When to use BlockingCollection and when ConcurrentBag instead of List?
  12. Detect target framework version at compile time
  13. Save byte[] into a SQL Server database from C#
  14. The opposite of Intersect()
  15. Convert DataTable to generic List?
  16. System.UnauthorizedAccessException: Retrieving the COM class factory for Word Interop fails with error 80070005
  17. Convert object to JSON string in C# [duplicate]
  18. Best Practice for Exception Handling in a Windows Forms Application?
  19. How to start Process hidden?
  20. Timer in UpdatePanel
  21. Register a dll into the GAC – but then it doesn’t show up in the assembly window
  22. Paste Event in a WPF TextBox
  23. What is the difference between UseStaticFiles, UseSpaStaticFiles, and UseSpa in ASP.NET Core 2.1?
  24. How to pass a nullable type to a P/invoked function [duplicate]
  25. What does exclamation mark mean before invoking a method in C# 8.0? [duplicate]
  26. Deserializing JSON into an object with Json.NET
  27. Why does my C# client, POSTing to my WCF REST service, return (400) Bad Request?
  28. RichTextBox Newline Conversion?
  29. MVC 4 – Many-to-Many relation and checkboxes
  30. Best way to iterate folders and subfolders

Leave a Comment