Getting return value from stored procedure in C#

by

Mehrdad makes some good points, but the main thing I noticed is that you never run the query…

SqlParameter retval = sqlcomm.Parameters.Add("@b", SqlDbType.VarChar);
retval.Direction = ParameterDirection.ReturnValue;
sqlcomm.ExecuteNonQuery(); // MISSING
string retunvalue = (string)sqlcomm.Parameters["@b"].Value;

More Related Contents:

  1. SQL Server Char/VarChar DateTime Error [closed]
  2. Delete from two tables? [closed]
  3. How to get last inserted id?
  4. What are the pros and cons to keeping SQL in Stored Procs versus Code [closed]
  5. Insert entire DataTable into database at once instead of row by row?
  6. SQL error: Incorrect syntax near the keyword ‘User’
  7. What represents a double in sql server?
  8. Passing List to SQL Stored Procedure
  9. Query extremely slow in code but fast in SSMS
  10. How to retrieve data from a SQL Server database in C#?
  11. Code to validate SQL Scripts
  12. Any way to SQLBulkCopy “insert or update if exists”?
  13. SQLException : String or binary data would be truncated
  14. Multi threading C# application with SQL Server database calls
  15. What’s the fastest way to bulk insert a lot of data in SQL Server (C# client)
  16. Generate class from database table
  17. ALTER TABLE DROP COLUMN failed because one or more objects access this column
  18. When executing a stored procedure, what is the benefit of using CommandType.StoredProcedure versus using CommandType.Text?
  19. Can I use ADFS 2.0 to authenticate certain users against SQL Server?
  20. ExecuteNonQuery returning -1 when using sql COUNT despite the query string
  21. What is passing parameters to SQL and why do I need it?
  22. Add WHERE clauses to SQL dynamically / programmatically
  23. How to pass string array in SQL parameter to IN clause in SQL
  24. How to pass a null variable to a SQL Stored Procedure from C#.net code
  25. How to insert data into SQL Server
  26. Query validation using C#
  27. Use SQL Server time datatype in C#.NET application?
  28. Generating sql code programmatically
  29. How to give ADO.NET Parameters
  30. Is SqlConnection.Close() need inside a Using statement?

Leave a Comment